Oooh, I like it! I'll try it. Thanks!

"T. Valko" wrote:

You have to nest another lookup testing for blank:

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

--
Biff
Microsoft Excel MVP


"smartgal" wrote in message
...
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?