Forum Discussion
Returning blank if equal cell value is found
If the value in cell A1 is found in the array D4:D4, I want the cell C1 to be blank. But if the value in cell A1 isn't found in the array D4:D4, I want the cell C1 to print the value of cell A1. Ho...
I assume that you meant the array D1:D4 instead of D1:D4.
In C1:
=IF(ISNUMBER(XMATCH(A1:A4, D1:D4)), "", A1:A4)
This will spill to C1:C4.