SkysLastChance
New Member
- Joined
- Mar 31, 2017
- Messages
- 3
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.
=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.