Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested if/then or array???
I've been using the vlookup function to reference a cell value (Sofa,
Loveseat, Chair, etc), find it in an existing list/chart and return the standard value in a given column. Ex: =vlookup(r3, Lookups!A4:Z27,19,False) Works great. I've run into trouble however when in certain places I FIRST need to know which of three OTHER cells have been selected. (Ex: Fabric, Leather, Lthr Combo) The one selected will change which column I need to reference in the vlookup. In other words this becomes instead of just "Sofa" - now it's a "Fabric, Sofa" or "Leather, Sofa" or "Lthr Combo, Sofa". In my formula cell I need to first know which cell was selected of the three above and then reference the cell that is hooked up to the vlookup list/chart. If fabric is selected I will need to look at column 13 not 19, leather 14 not 19, etc..... I can't seem to nest the if/thens correctly - or am needing to take a different approach altogether. If you can be of any assistance your help would be much appreciated. Or if I can try and provide you further detail. Thanks so much. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested if/then or array???
Bob your brilliant!!! Can't thank you enough!!!! Have a great day!
Karin "Bob Phillips" wrote: =vlookup(r3, Lookups!A4:Z27,IF(fabric,13,IF(leather,14,19)),Fal se) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Karin B" <Karin wrote in message ... I've been using the vlookup function to reference a cell value (Sofa, Loveseat, Chair, etc), find it in an existing list/chart and return the standard value in a given column. Ex: =vlookup(r3, Lookups!A4:Z27,19,False) Works great. I've run into trouble however when in certain places I FIRST need to know which of three OTHER cells have been selected. (Ex: Fabric, Leather, Lthr Combo) The one selected will change which column I need to reference in the vlookup. In other words this becomes instead of just "Sofa" - now it's a "Fabric, Sofa" or "Leather, Sofa" or "Lthr Combo, Sofa". In my formula cell I need to first know which cell was selected of the three above and then reference the cell that is hooked up to the vlookup list/chart. If fabric is selected I will need to look at column 13 not 19, leather 14 not 19, etc..... I can't seem to nest the if/thens correctly - or am needing to take a different approach altogether. If you can be of any assistance your help would be much appreciated. Or if I can try and provide you further detail. Thanks so much. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested if/then or array???
"Karin B" wrote in message ... Bob your brilliant!!! Can't thank you enough!!!! Have a great day! I will now <bg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nested MATCH within Array formula? | Excel Worksheet Functions | |||
nested array formula's | Excel Worksheet Functions | |||
Nested array functions? | Excel Worksheet Functions | |||
Nested if in Array | Excel Worksheet Functions | |||
How do I use wild cards in nested array formulas? | Excel Worksheet Functions |