title: Get multiple keywords in a range using VBA code
body: <p>I am working on large excel files and i need a way to automate the work using VBA code, Here is a brief of what I do and what i need:</p>
  
  <p>I have a column containing titles and i search manually for a certain value and then i write the value down in another column, and then i search for another value and repeat the same step, if i found 2 values then i write it down in the same cell separated by comma,</p>
  
  <p>What i need is a script that lookup the first value in the table of values and search for it in the Title column and retrieve the value in adjacent column, then repeat this step for each value in the table.</p>
  
  <p>See below Example:</p>
  
  <p>Table 1: containing values to search for</p>
  
  <pre><code>Values
  VBA
  Excel
  Data
  Format
  Sum
  Replace
  </code></pre>
  
  <p>Table 2: Containing Titles</p>
  
  <pre><code>Title
  Excel VBA Code to find and Replace
  VBA/ Excel determine if cell has a data validation error with vba code
  Excel VBA - Finding a relative range of data
  Excel VBA code to negate values
  </code></pre>
  
  <p>And the result would be values found, as in the image below:</p>
  
  <p><a href="https://i.stack.imgur.com/1HCXB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1HCXB.png" alt="enter image description here"></a></p>
  
  <p>I hope this is clear enough, I need it as dynamic as possible.
  I appreciate any help
  Thank you</p>