| 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 |
| 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 | |||
Threaded Mode
