Help with a formula

[Andy295]

Hi

Im trying to make a formula that can take keywords i specify and change them to the name of where they are located in an adjacent cell.

This is how far i have got =IF(OR(ISNUMBER(SEARCH("Cap",A2)),ISNUMBER(SEARCH("Hat",A2)),ISNUMBER(SEARCH("Snapback",A2))),"Cap Room")

but i don't know how to add additional parimeters e.g. umbrellas shows as Umbrella Room etc

Thanks

Andy

 

[Joe4]

Welcome to the Board!

Why not set up a lookup table and use VLOOKUP?
https://www.techonthenet.com/excel/formulas/vlookup.php