Need Help in Simple Lookup Function
=IF(ISERROR(VLOOKUP($E$2,L:Q,5,FALSE)),"Not
Available",VLOOKUP($E$2,L:Q,5,FALSE))
this is what i am using, as u suggested, but its returning 0
instead of "not available"
"muddan madhu" wrote:
=if(iserror((your_formula),"not available",your_formula)
On Oct 7, 8:40 pm, 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
|