| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Help in Simple Lookup Function
=IFERROR(VLOOKUP($E$2,L:O,4,FALSE), "Not Avialable")
hi, I am using this (above) equation, to do lookups from 5 columns. the lookup thing is working but when there is nothing in the cell (that the function looking up) it returns 0 instead of "Not Available" (as in the equation). i want the function to show "Not available" when the cell is blank, or there is an error. thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| Can anyone help with a Simple Lookup please? | Excel Discussion (Misc queries) | |||
| Simple lookup - or maybe not so simple - help! | Excel Worksheet Functions | |||
| simple lookup | Excel Discussion (Misc queries) | |||
| Lookup help (simple) | Excel Worksheet Functions | |||
Threaded Mode
