What is the data type of the returned value?

If it's TEXT try this:

=IF(ISERROR(VLOOKUP($A7,BB!$A$1:$S$5000,5,0)),"",T (VLOOKUP($A7,BB!$A
$1:$S$5000,5,0)))

If it's numeric will 0 be an otherwise valid result?

--
Biff
Microsoft Excel MVP


"Debbie" wrote in message
...
Hi!

The problem I am having is in the lookup table, sometimes row 5 is
empty. When it is, it puts a zero in my cell. I want it to be blank.
Can I do this? I have pasted my formula.

=IF(ISERROR(VLOOKUP($A7,BB!$A$1:$S$5000,5,FALSE)), "",VLOOKUP($A7,BB!$A
$1:$S$5000,5,FALSE))