Hi!

Instead of "padding" the lookup table just write your
formula to check for zero. Something like this:

=IF(VLOOKUP(A1,B:D,3,0)=0,"",VLOOKUP(A1,B:D,3,0))

Biff

-----Original Message-----
Hello:

I have lookup table but I have cells that have zeros.
What can I insert in
the lookup table so when a zero is looked up and matched
It will be a
blank cell.

I have tried placing a zero and then a blank, but it
returns a zero.

Thanks,

Zetastrat
.