Forum Discussion

Copper Contributor

Sep 20, 2017

Solved

Trying to insert another if statement in an "IF(ISNUMBER(MATCH" statement.

So I have the following formula working fine, BUT what I am trying to do is change the return values, where return value "1" is a second "IF" statement. =IF(ISNUMBER(MATCH(Schedule!B2,Schedule...

Formulas & Functions

Need Help

Detlef_Lewin
Sep 20, 2017
Greg,

remove the equal sign before the second IF.
=IF(ISNUMBER(MATCH(A39,A2:A131,0)),IF(C40="win",C449,"X"),0)

Detlef_Lewin

Silver Contributor

Sep 20, 2017

Greg,

remove the equal sign before the second IF.

=IF(ISNUMBER(MATCH(A39,A2:A131,0)),IF(C40="win",C449,"X"),0)