title: Google Sheet match category with multiple keywords to strings
body: <p>How do I match a category list(column <code>D</code>) with 3 columns of keywords (columns <code>A B C</code>) to a list of strings(column <code>H</code>) and have the result of column <code>I</code>?</p>
  
  <p>I was thinking vlookup and tried something like this, but looks like it doesn't work: </p>
  
  <pre><code>=vlookup("*"&amp;A2:A&amp;"*"&amp;B2:B&amp;"*"&amp;C2:C&amp;"*",H2:H,1)
  </code></pre>
  
  <p>I was also considering <code>QUERY</code>, but I don't think that can match by row either. </p>
  
  <p>Any help is appreciated!</p>
  
  <p>spreadsheet: <a href="https://docs.google.com/spreadsheets/d/1AHT5d4KkZ49csitkICUd7ANwjWMZXk9GAZA_5pVZlrs/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1AHT5d4KkZ49csitkICUd7ANwjWMZXk9GAZA_5pVZlrs/edit#gid=0</a></p>
  
  <p>For example:</p>
  
  <p><a href="https://i.stack.imgur.com/n63BT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/n63BT.png" alt="enter image description here"></a></p>