Hi,
I want to combine the following list of IF statements, but I have no idea how to do it. I can see tutorials on nesting them, but that isn't what I want to do. Any help gratefully appreciated.
Cheers,
Alex.
=IF(ISNUMBER(SEARCH("*Doubles",J2)), "Doubles","")
=IF(ISNUMBER(SEARCH("*Minor",J2)), "Minor","")
=IF(ISNUMBER(SEARCH("*Triples",J2)), "Triples","")
=IF(ISNUMBER(SEARCH("*Major",J2)), "Major","")
=IF(ISNUMBER(SEARCH("*Caters",J2)), "Caters","")
=IF(ISNUMBER(SEARCH("*Royal",J2)), "Royal","")
=IF(ISNUMBER(SEARCH("*Cinques",J2)), "Cinques","")
=IF(ISNUMBER(SEARCH("*Maximus",J2)), "Maximus","")
=IF(ISNUMBER(SEARCH("*Sextuples",J2)), "Sextuples","")
=IF(ISNUMBER(SEARCH("*Fourteen",J2)), "Fourteen","")
=IF(ISNUMBER(SEARCH("*Septuples",J2)), "Septuples","")
=IF(ISNUMBER(SEARCH("*Sixteen",J2)), "Sixteen","")
=IF(ISNUMBER(SEARCH("*Triples*Major",J2)), "Triples & Major","")
=IF(ISNUMBER(SEARCH("*Caters*Royal",J2)), "Caters & Royal","")
=IF(ISNUMBER(SEARCH("*Cinques*Maximus",J2)), "Cinques & Maximus","")
Bookmarks