If match = n/a?

[lavezzi7]

Hey guys,

I know this is an FAQ within forums, I have been trying different solutions found via Google but nothing worked.

I am using an IF statement in conjunction with a match formula and the condition outcomes for TRUE or FALSE.

=IF(MATCH(C2;Sheet2!$E$2:$E$21;0);"ACTION";"NO ACTION")

The problem is that when the condition is FALSE i get N/A instead of "NO ACTION".

As I already mentioned I tried different formulas like IFNA/ IFERROR but without any success so far.

Is there is a formula that would give me a different result depending whether the condition is TRUE or FALSE?

Any advice is highly appreciated!

Thanks in advance!!

 

[sandy666]

try =IF(IFNA(MATCH(C2;Sheet2!$E$2:$E$21;0);0);"ACTION";"NO ACTION")

 

[lavezzi7]

Works like a treat!

Thanks Sandy

 

[sandy666]

You are welcome
Have a nice day