Maybe...

=IF($B4=Status!$B4,if(Status!C4="","",status!c4)," ")


KC wrote:

I'm using the following formula to bring data over from one tab to another,
however, if there is nothing in cell B4 on the Status tab its returning a 0
in the cell. I don't want to see anything in the cell. What do I have to do
to modify this? Thanks in advance.

=IF($B4=Status!$B4,Status!C4,"")

I tried this formula, but it also didn't work - still displays 0

=IF(ISERR(IF($B4=Status!$B4,Status!C4,"")),"",IF($ B4=Status!$B4,Status!C4,""))

--

Dave Peterson