so what should i be using, to return "not available" when it (lookup) finds
the cell is blank or an error


"Sheeloo" wrote:

IFERROR will return 'Not Available' only if VLOOKUP returns an error. It will
return the value VLOOKUP returns if there is no error... You may put an IF
around it to check for 0 and return "Not Available"...

"Raz" wrote:

=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