Need Help in Simple Lookup Function
well that is my whole purpose here,
i want equation to return "not available" if the cell is blank.
it is returning 0, and i need to fix that, everything else is working fine.
thanks again.
"Sean Timmons" wrote:
That would be due to the matching value in your P column is either blank or
the value 0.
"Raz" wrote:
=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"
|