help in If error

[Raz]

=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

 

[Sean Timmons]

We answered your question in the other category. Please refrain from asking
this question in multiple places until you've given us a chance to respond.

 

[Sheeloo]

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]

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