Help with a formula

Andy295

New Member
Joined
Mar 7, 2018
Messages
1
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
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,090,307
Messages
5,413,695
Members
403,496
Latest member
chamshop

This Week's Hot Topics

Top