Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup
I have 3 options, cell A1 contains the words Staff,Contract, a range of other
texts or it may be blank Can Lookup return values for each? I have = LOOKUP(A1,{"Staff","Contract"," ",""},{1,2,3,""}) but this is not returning the expected values...I suspect I do not understand the necessary order required for this formula ....please advise Thank you |
#2
|
|||
|
|||
You can't lookup a blank cell but you could use this
=IF(A1="","",VLOOKUP(A1,{"Staff",1;"Contract",2;" ","3"},2,0)) -- Regards, Peo Sjoblom "nussbaum" wrote in message ... I have 3 options, cell A1 contains the words Staff,Contract, a range of other texts or it may be blank Can Lookup return values for each? I have = LOOKUP(A1,{"Staff","Contract"," ",""},{1,2,3,""}) but this is not returning the expected values...I suspect I do not understand the necessary order required for this formula ....please advise Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup tables in cells | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
Lookup Problem | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |