Easy enough..

=IF(VLOOKUP($E$2,L:Q,5,FALSE)=0,"Not Available",VLOOKUP($E$2,L:Q,5,FALSE))

If you want both errors and 0 to be captured:

=IF(OR(ISERROR(VLOOKUP($E$2,L:Q,5,FALSE)),VLOOKUP( $E$2,L:Q,5,FALSE)=0),"Not
Available",VLOOKUP($E$2,L:Q,5,FALSE))


"Raz" wrote:

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"