I need a larger "IF" Formula...

D

Drew

I am trying to expand my if formula to go through 26 option. however i need
it to return cells not numbers ie =if(a1="a through z",here i need 26
coresponding cells.
I tried "lookup" but it will not let me put cells in the result vector.
should i be using a different formula?
 
G

Gary's Student

Try VLOOKUP, it will allow text look-ups. If you have trouble entering cell
references, then use the INDEX function instead.
 
A

Andy Wiggins

=CHOOSE(CODE(A1)-96,B1,B2,B3,B4, ... etc ..)

Change the 96 to 64 if you use upper case characters
 
Top