need look up table to return blank
 

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

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
.

zetatstrat Wrote:
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

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

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


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=319973