Lookup

N

nussbaum

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
 
P

Peo Sjoblom

You can't lookup a blank cell but you could use this

=IF(A1="","",VLOOKUP(A1,{"Staff",1;"Contract",2;" ","3"},2,0))
 
Top