It's a formula error. The correct formula is:

=IF(ISERROR(VLOOKUP($E$2,L:O,4,FALSE)), "Not Available")

Although presumably you want to return the value from VLOOKUP if it's not an
error, so..

=IF(ISERROR(VLOOKUP($E$2,L:O,4,FALSE)), "Not
Available",VLOOKUP($E$2,L:O,4,FALSE))


"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