help in If error

  • Thread starter Thread starter Raz
  • Start date Start date
R

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
 
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.
 
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"...
 
so what should i be using, to return "not available" when it (lookup) finds
the cell is blank or an error
 
Back
Top