Forum Discussion
IF=TRUE=X IF=FALSE=BLANK
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 formu...
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", "")
ie
=IF( ISNUMBER( MATCH( )), "X", "")