I need a larger "IF" Formula...
 

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?

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


"Drew" wrote:

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?

Likely, you need a vlookup. See he
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Drew" wrote in message
...
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?

You can use a VLookup formula to return the corresponding value. There
are instructions for VLookup in Excel's help, and he

http://www.contextures.com/xlFunctions02.html

Drew wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

Change the 96 to 64 if you use upper case characters

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Drew" wrote in message
...
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?