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
In the attached file, I modified Sheet2!A26 from "Manager Position" to "Role" so that it will coincide with Sheet1!C1. Thereafter, a simple VLOOKUP will return your desired results in Sheet2!B26:B29. Thus, the formula in Sheet2!B26, copied down to Sheet2!B29, is:
=VLOOKUP(B$25,Sheet1!A$2:G$31,
MATCH(A26,Sheet1!A$1:G$1,0),0)
Twifoo Great! thank you
- It's a pleasure to know that!