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 |
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
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
A simple SUMIFS should do the trick
Sunny