IF=TRUE=X IF=FALSE=BLANK

[Freddy1510]

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!

[#2]

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.
ie
=IF( ISNUMBER( MATCH( )), "X", "")