shawnthegrom
New Member
- Joined
- May 12, 2015
- Messages
- 1
Hi All,
I have thousands of text strings in Column A on Sheet 1 such as "hotels in chicago" and then I have a list of text values in Column A of Sheet 2 that contain possible category matches such as "hotels" or "flights". I'm trying to get Column B in Sheet 1 to give me the category of the text in Column A by searching the cell for a match in Sheet 2.
For example, if Sheet1 - A1 is "hotels in chicago" and Sheet 2 - A1-A100 contains "hotels", then Sheet 1 - Column B should return "hotels". If not, then leave blank.
I've tried all kinds of SEARCH, MATCH, INDEX and VLOOKUP formulas. The best option I have at the moment is to add each value from Sheet 2 - Column A in the formula itself like this:
=IF(OR(ISNUMBER(SEARCH({"hotel","room","marriott","hilton"},A2))),"hotels","")
I'd like to use Sheet 2 for my list of possible matches instead.
Thanks!
I have thousands of text strings in Column A on Sheet 1 such as "hotels in chicago" and then I have a list of text values in Column A of Sheet 2 that contain possible category matches such as "hotels" or "flights". I'm trying to get Column B in Sheet 1 to give me the category of the text in Column A by searching the cell for a match in Sheet 2.
For example, if Sheet1 - A1 is "hotels in chicago" and Sheet 2 - A1-A100 contains "hotels", then Sheet 1 - Column B should return "hotels". If not, then leave blank.
I've tried all kinds of SEARCH, MATCH, INDEX and VLOOKUP formulas. The best option I have at the moment is to add each value from Sheet 2 - Column A in the formula itself like this:
=IF(OR(ISNUMBER(SEARCH({"hotel","room","marriott","hilton"},A2))),"hotels","")
I'd like to use Sheet 2 for my list of possible matches instead.
Thanks!
