title: Excel - categorize an entry from an array of keywords
body: <p>So my situation:</p>
  
  <p>I have thousands of entries in a column of business locations. I have created a table of of categories with associated keywords. The idea is that if a location has one of these keywords in its name, it will have a certain category as a result.</p>
  
  <p>So in B1 I have a category of "Hotels" and in C1, "Inn", D1, "hotel", E1, "lodge", etc.
  And in C2, I have another category name called "Retail" with keywords going across to the right such as "Mall" in D2, "Shopping" in E2, etc. There are 20 such categories in a table i a separate tab that the locations tab will reference for the categorization.</p>
  
  <p>If the entry has any of these words, I want to a new column next to it called "Category" to return "Hotel" in the same row. It is easy to do this for just the hotel category since that is just a boolean return.</p>
  
  <p>But I have 20 categories like this and do not want to manually write the find statements for all of them because I want to search for all of the keywords and return the matching category name. Is there a succinct way of doing this?</p>
  
  <p>One idea I had is to delimit each location string by spaces and splice the words into an array, then say if any of theme match the horizontal arrays next to the category names in the reference table, find the row of the match (since all the category names are in the same column) and complete the cell reference with an indirect. I am not sure how to write such a statement and if that is the optimal way to address this issue.</p>
  
  <p>Any help would be greatly appreciated!</p>