MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cell lookup returning '0'

Posted by lucky on December 28, 2001 6:39 AM

I am using a simple cell lookup in an adjacent cell (i.e =B1) and this returns '0' (zero) when that cell is not populated. Is it possible to make this cell blank when the reference cell is also blank?

Thanks in anticipation

Posted by Scott on December 28, 2001 6:42 AM

Try this formula:


Posted by lucky on December 28, 2001 6:51 AM

Thanks Scott!

Posted by Joseph Cowan on December 28, 2001 7:52 AM

I am doing lookups and had set the process up so that if the lookup pulls data = 0 it prints a "".
So, If I look up this week, days in advance of today will normally show 0, they now show "".
However, when I do a line chart to display the week to date, I get a point for today that falls off to 0 for tomorrow & looks ugly. I would like the chart to show nothing for tomorrow & have the line just stop rather than dropping from 5432 to 0. The cell is empty but the 0 still plots.