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