Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
=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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |