title: Need Fastest Search Method in Excel VBA
body: <p>Consider a scenario, I have 2 columns (Column "A" &amp; Column "B").</p>
  
  <p>Column A has around 130000 rows/Strings
  Column B has around 10000 rows/Strings</p>
  
  <p>I would like to search each string of Column "B" from Column "A".</p>
  
  <p>As you can see the volume of data is very high. I have already tried with Range.Find() method. But it's taking lot of time to complete. I am searching for a method/way that will give me result in very less turnaround time.</p>
  
  <p><em><strong></em>* Some more Clarification on my requirement <em>*</em></strong></p>
  
  <p>(1) Column A &amp; B contains string values, NOT NUMBERS. And the string can be very large</p>
  
  <p>(2) For each cell in column "B", There can be many occurrence in column "A"</p>
  
  <p>(3) I would like to fetch all the occurrence of column "B"  in column "A" with Row Number</p>
  
  <p>(4) For a string present in column "B". It can be found as a Substring of any cell in column "A"</p>
  
  <hr>
  
  <p><em><strong></em> Download file link - wikisend.com/download/431054/StackOverFlow_Sample.xlsx <em>*</em></strong></p>
  
  <p>Any Suggestions ?</p>
  
  <p>Feel free incase you need any extra details to solve above problem !</p>