title: Excel keyword exact match from list of keywords in dataset
body: <p>I am struggling to create a formula on matching the exact list of keywords to a dataset. I have tried many formulas but seems like nothing is working. My requirement is to detect keywords from the list of keywords mentioned in column 'R<code>and data set is present from column</code>B<code>to column</code>N<code>. If suppose there are two keywords found in </code>row 2<code>then it will give me</code>True<code>value and name of those two keywords that are found. Also if keyword is</code>BAT` and in data set we have something like BATMAN then it should not detect Batman for keyword BAT.</p>
  <p>Formula I tried
  <code>=IFERROR(INDEX($R$2:$R$5,MATCH(TRUE,SEARCH($R$2:$R$5,B2)&gt;0,0)),&quot;Not found&quot;)</code></p>
  <p><a href="https://i.stack.imgur.com/2CS5R.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2CS5R.png" alt="enter image description here" /></a></p>