I have this formula on cells in my spreadsheet:
The spreadsheet contains a value in A1 which can vary. The data as you can see comes from another spreadsheet. If the A1 value does not match the Data spreadsheet D4 cell, I want a blank or null. Now I am getting zeros when there is no match.
I hope this makes sense.