I am using a =IF(MATCH function and I get an #N/A
Here is my formula:
=IF(MATCH(A1, '[Workbook 2]Sheet 1A:A,0), "X", ""
If I get an exact match in my Workbook 2, the formula works fine, It add my "X" in the cell. But if the value is FALSE, it doesnt return blank. I get an #N/A
What am I doing wrong?