Guys this is probably so basic, but I cant get it.
I have a column of data of which I am using the '=' to match that data in another cell (if cell A2 contains '123', then cell D2 shows '123').
But when there is no data in the cell, it returns a '0'. I want it to return a blank cell instead of a '0'.
Thanks for looking.
Bookmarks