Yeah, that's another alternative as long as the "hidden" 0 doesn't mess up
any downstream calculations.

--
Biff
Microsoft Excel MVP


"smartgal" wrote in message
...
Never mind, just conditionally formatted so that if the value is "0" the
text
is white . . .

"smartgal" wrote:

I have the following formula:

=IF(ISERROR(VLOOKUP(A5,Input!A:B,2,0)),"",VLOOKUP( A5,Input!A:B,2,0))

If I don't have an entry in my "input" sheet, it returns a value of "0."
What I *want* it to do is to not show anything if there's no entry. Can
I
just make it look blank?