Forum

Notifications
Clear all

Complex if query

4 Posts
4 Users
0 Reactions
103 Views
(@dileepav80)
Posts: 1
New Member
Topic starter
 

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
 
Posted : 04/09/2018 10:28 am
Anders Sehlstedt
(@sehlsan)
Posts: 971
Prominent Member
 

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

 
Posted : 05/09/2018 11:58 am
(@fravis)
Posts: 337
Reputable Member
 

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

 
Posted : 06/09/2018 1:51 pm
(@sunnykow)
Posts: 1417
Noble Member
 

A simple SUMIFS should do the trick

Sunny

 
Posted : 06/09/2018 7:03 pm
Share: