Match with Multiple Criteira

[SkysLastChance]

So this formula works great. It looks for apple in a range and returns yes if it finds it. However, I would like to be able to look for multiple things and return yes if any of the items are found. If possible I would like it to return the value of the first one found.

=IF(ISNUMBER(MATCH({"Apple",""},Q2:AO2,0)),"Yes","No")

I have tried a couple diffrent ways with no luck.

=IFERROR(IF(MATCH("Apple",Q2:AO2,0),"Apple",IFERROR(IF(MATCH("Z66",Q2:AO2,0),"Banana",),"BBanana")),"")


Any help is appreciated.

 

[Eric W]

Maybe:

=IFERROR(INDEX(Q2:AO2,AGGREGATE(15,6,MATCH({"apple","banana"},Q2:AO2,0),1)),"No Match")

 

[SkysLastChance]

This does the trick for what I need. Thank You!