Nested IF and MATCH statement issue

[deckerch]

I am trying to create a project rollup cell based on the values of the values of the subtasks under the main task. The formula I'm using is:

=IF(ISTEXT(MATCH("Need Help",$F3:$F7)),"Need Help",IF(MATCH("Some Issues",$F3:$F7),"Some Issues",IF(MATCH("On Track",$F3:$F7),"WTF?")))

My data set contains all three responses. The result I'm getting is "Some Issues". I would have expected that the "Need Help" would solve first and that would be the answer. Any suggestions?

Thanks in advance for any assistance!

 

[deckerch]

That's on me. Forgot the match style deliminator, so it was default to "1" which is a similiar match. Try this:

=IF(ISNUMBER(MATCH("Need Help",$F3:$F7,0)),"Need Help",IF(ISNUMBER(MATCH("Some Issues",$F3:$F7,0)),"Some Issues",IF(ISNUMBER(MATCH("On Track",$F3:$F7,0)),"On Track", "No Match")))

Works like a champ now. Thank you!