On Oct 12, 9:31*pm, Jacob Skaria
wrote:
'if col 5 is text then you can try
=IF(ISERROR(VLOOKUP($A7,bb!$A$1:$S$5000,5,FALSE)), "",T(VLOOKUP($A7,bb!$A$1:*$S$5000,5,FALSE)))

'or other wise
=IF(ISERROR(VLOOKUP($A7,bb!$A$1:$S$5000,5,FALSE)), "",IF(VLOOKUP($A7,bb!$A$1*:$S$5000,5,FALSE)="","", VLOOKUP($A7,bb!$A$1:$S$5000,5,FALSE)))

If this post helps click Yes
---------------
Jacob Skaria



"Debbie" wrote:
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))- Hide quoted text -

- Show quoted text -

Thank you. The second works great.