Log In
Register
Home
New Member
September 4, 2018
Offline
I have a table of 3 columns A B C.
A has finish position.
B has turn position
C has Fixed Multiplier.
I need to use value in C depending on input of A and B in a formula. So if A is 1 and B is 2 then it should pull up 264 as shown in TABle below.
| Finish Position | Turn Position | Fixed Multiplier |
| 1 | 1 | 265 |
| 1 | 2 | 264 |
| 1 | 3 | 263 |
| 1 | 4 | 262 |
| 1 | 5 | 261 |
| 1 | 6 | 260 |
| 1 | 7 | 259 |
| 1 | 8 | 258 |
| 1 | 9 | 257 |
| 1 | 10 | 256 |
| 1 | 11 | 255 |
| 1 | 12 | 254 |
| 1 | 13 | 253 |
| 1 | 14 | 252 |
| 1 | 15 | 251 |
| 2 | 1 | 266 |
| 2 | 2 | 267 |
| 2 | 3 | 266 |
| 2 | 4 | 265 |
| 2 | 5 | 264 |
| 2 | 6 | 263 |
| 2 | 7 | 262 |
| 2 | 8 | 261 |
| 2 | 9 | 260 |
| 2 | 10 | 259 |
| 2 | 11 | 258 |
| 2 | 12 | 257 |
| 2 | 13 | 256 |
| 2 | 14 | 255 |
| 2 | 15 | 254 |
| 3 | 1 | 267 |
| 3 | 2 | 268 |
| 3 | 3 | 269 |
| 3 | 4 | 268 |
| 3 | 5 | 267 |
| 3 | 6 | 266 |
| 3 | 7 | 265 |
| 3 | 8 | 264 |
| 3 | 9 | 263 |
| 3 | 10 | 262 |
| 3 | 11 | 261 |
| 3 | 12 | 260 |
| 3 | 13 | 259 |
| 3 | 14 | 258 |
| 3 | 15 | 257 |
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Now I don't know how your real scenario / file is, but based on the provided table and question I would say you should use DGET or an array formula of INDEX and MATCH. See attached file for examples.
Br,
Anders
VIP
April 21, 2015
Offline
Well, for the finish position 1 I get it and then something like IF(A2=1,267-B2) and so downwards. Combining with A being 2 seems more difficult because first you have 2 with turn position 1 which gives apparently 266 and with turn position 2 267 and then going downwards. So you have to make different IF's for that two. The same with Finish position 3 with the first 3 turn positions.
This can be done, but I don't know how many Finish positions you want and what you want to do with it?
Frans
1 Guest(s)
