Is it possible to do an ELSE IF statement in Excel?
I'm trying to perform a task in which a drop-down box determines which value should activate a VLookup. The only approach I can think of is using nested IF statements but I'm thinking there must be a better way.
To better clarify:
=IF(C6=W8,VLOOKUP(...),IF(C6=W9,VLOOKUP(...),IF(C6=W10),VLOOKUP(...),etc)))
How should I approach this?
Bookmarks