Forum Discussion
Solved
How to Search text and return multiple values
Hi all, I'm a newbie with Excel formulas and I am struggling with trying to search a product description and return multiple values depending on the content. In the example in the screenshot bel...
=IF(OR(ISNUMBER(SEARCH("womens",A1)),ISNUMBER(SEARCH("ladies",A1))),"Ladies",IF(ISNUMBER(SEARCH("boys",A1)),"Boys",IF(ISNUMBER(SEARCH("girls",A1)),"Girls",IF(ISNUMBER(SEARCH("mens",A1)),"Mens",""))))
Is this what you are looking for?
=IF(OR(ISNUMBER(SEARCH("womens",A1)),ISNUMBER(SEARCH("ladies",A1))),"Ladies",IF(ISNUMBER(SEARCH("boys",A1)),"Boys",IF(ISNUMBER(SEARCH("girls",A1)),"Girls",IF(ISNUMBER(SEARCH("mens",A1)),"Mens",""))))
Is this what you are looking for?
OliverScheurich Indeed it is thanks for the quick response! 🙂