Hi all
I'm wanting to do an Index Match with an IF that will lookup; Column 1 if A1 = 0, Column 2 if A1 = 1, and Column 3 if A1 = 3.
I have the current start of the formula for 2 columns:
=INDEX(C2:E29,MATCH(CellLookupValue,B2:B29),IF(A1,2,1))
I'm aware the IF statement at the end now will need to change, but I'm unsure how.
A1 will either have the values 0, 1, or 2
The table range is C2 to E29 (3 columns)
The B column of the table is obviously for the Match and will link in to a Cell Value of my choice (which we could call A2 for now if you need an example)
Kind regards
Bookmarks