New Contributor

Hi everyone, 


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?


Thank you!

1 Reply
Your Logical_Test (Match Function) does not return True/False. It will either return a number or #N/A. Wrap your Match() function with IsNumber() function.
=IF( ISNUMBER( MATCH( )), "X", "")