title: Match value from a table and print the results on a column
body: <p>I would like to build an excel VBA program to find all the match values from a table and print the finding on a column... I tried to use vlookup but only gives me the first location that finds... and I would like all the finds.</p>
  
  <p>here is an example:
  my table starts on cell A2</p>
  
  <ul>
  <li>column A (number) </li>
  <li>0084</li>
  <li>0084 </li>
  <li>0085</li>
  <li>0085</li>
  <li>0086</li>
  <li><p>0087</p></li>
  <li><p>column B (location)</p></li>
  <li>12AC5 </li>
  <li>16AC5</li>
  <li>02AC5</li>
  <li>06AC5</li>
  <li>01DC5</li>
  <li>11DC5</li>
  </ul>
  
  <p>on column D I paste the values I am looking for there location..... on column F would give me all the location found that matches my request... in ascending order or any order</p>
  
  <p>for example I am looking for the location of 2 numbers:</p>
  
  <ul>
  <li>column D (I paste the number that I what to see there location   </li>
  <li>0084 </li>
  <li>0087</li>
  </ul>
  
  <p>I expect to see the results:</p>
  
  <ul>
  <li>column F(found location)</li>
  <li>12ac5</li>
  <li>12bd5</li>
  <li>16ac5</li>
  </ul>
  
  <p>Any help with this would be very much appreciated..</p>
  
  <p>Cheers,
  JFFC
  excel VBA</p>
  
  <pre><code>enter code here
  </code></pre>