If you think logically, the cell is NOT empty, (truely or otherwise) as
it contains a formula. What you are really doing is forcing the cell
to not display its contents with IF(.....,"").

AFAIK, there is no way to make a cell with a formula act as if it
doesn't exist.

One option to explore is to use Find. Highlight the column you want to
search. Click CTRL+F. In the "Find What", enter the Error (#N/A, #VALUE,
etc.). Then click on Options to search "By Columns" and set Look In to:
Values.

Not too bad, especially if you have a very long column to look
through.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=393270