IF function returns NA when FALSE?

[Camel123]

Hi,

How do I get the first IF function to return FALSE instead of NA? What is wrong in the formula.

=IFERROR(IF(A21=INDEX(P:P;MATCH(A21;P:P;0));TEXT(INDEX(S:S;MATCH(A21;P:P;0));0);TEXT((INDEX(R:R;MATCH(A21;T:T;0)));0));"")

All fields are formatted identically.

 

[Special-K99]

In words, what are you trying to do.

I see and an IF with a result for TRUE and a result for FALSE

So where does your extra FALSE fit in? You can only have 1 TRUE and 1 FALSE inan IF condition

 

[Fluff]

Maybe
=IFERROR(IF(A21=IFERROR(INDEX(P:P;MATCH(A21;P:P;0));"");TEXT(INDEX(S:S;MATCH(A21;P:P;0));0);TEXT((INDEX(R:R;MATCH(A21;T:T;0)));0));"")

 

[Camel123]

<3 thanks to both of you for your efforts, @Fluff, it worked awesome. Appreciate it!

 

[Fluff]

You're welcome & thanks for the feedback