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
9 Replies
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?
- Please attach your sample file so I can see what's causing the error.
