IF function returns NA when FALSE?

Cameltoe

Board Regular
Joined
Jun 5, 2018
Messages
175
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

Well-known Member
Joined
Nov 7, 2006
Messages
8,314
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,487
Office Version
365
Platform
Windows
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));"")
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,487
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Forum statistics

Threads
1,078,393
Messages
5,339,923
Members
399,340
Latest member
JasonT903

Some videos you may like

This Week's Hot Topics

Top