Forum Discussion

Freddy1510's avatar
Freddy1510
Copper Contributor
Feb 24, 2023

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 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!

excel
Formulas and Functions

1 Reply

  • FikturFox's avatar
    FikturFox
    Brass Contributor
    Feb 24, 2023
    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", "")

Resources