VLOOKUP Returning Blank OR Zeros ?

[sasquatchbill]

Hello,

I have a VLOOKUP function that should return a "1", "2", "4", "0", or a null value. (Don't ask about the order of those numbers - my dept is messed up.)

The problem is, that any null values that are returned are then displayed as 0, which doesn't allow me to differentiate between the different values.

How do I ensure that nulls are returned as null and 0's are 0. I have no problems with any of the other numbers.

Thank you very much in advance for your help!
-Will

PS - here's the formula, if you're wondering:
=VLOOKUP(A85,Projects!$A$8:$M$1000,9,FALSE)

[oldchippy]

Does this work?

=VLOOKUP(A85,Projects!$A$8:$M$1000>0,9,FALSE)

[Mark@Work]

The best I could come up with is:

=IF(ISBLANK(VLOOKUP(C4,B6:C14,2,FALSE)),"",VLOOKUP(C4,B6:C14,2,FALSE))

[sasquatchbill]

Thanks OldChippy, but that didn't work.

I tried Mark@Work's technique and that seemed to do it for me!

Thanks to both of you for your help!