Forum Discussion
Multiple IF statements
I am looking at finding a formula for: =IF(B25=Sheet1!A2 than B26=Sheet1!B2 and B27=Sheet1!C2 .... and so on BUT =IF(B25=Sheet1!A3 than B26=Sheet1!B3 and B27=Sheet1!C3
It seems that you need a formula like this in B26, copied down rows:
=INDEX(CHOOSE(1+(B$25=Sheet1!A$3),
Sheet1!B$2:J$2,Sheet1!B$3:J$3),
ROW()-25)
I have tried your formula and it works for the first drop down, but when I drop down to the second name which is on Sheet1!A$2 it doesnt pick up the line he is on. Am I missing something?
