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.
However, the cells adjacent to the array automatically ''joins'' the formula and the input becomes grey.
What I want:
What I write:
What I get (with the automatic input in cell C2, C3, and C4 in grey):
Anyone who could help?
1 Reply
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.
