need look up table to return blank

[zetatstrat]

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

 

[Biff]

Hi!

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

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

Biff

 

[Aladin Akyurek]

Hello:

I have lookup table but I have cells that have zeros. What can
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

If the lookup table is sorted on its first column, try the recip
described in my contrib in:

http://www.mrexcel.com/board2/viewtopic.php?t=11694