title: Faster way to Vlookup and return multiple results?
body: <p>I have looked for over a day here in Stackoverflow and cannot find an answer to what I am trying to do.
  All I need is a vba code that Vlookups and return the multiple results, </p>
  
  <p>Eg; the lookup value is in sheet1 A1, data is in sheet2 columns A1:B40000, match the values in sheet2 A1:A40000 and returns the values from Sheet2 column B1:B40000.</p>
  
  <p>Note:Its possible to find upto 5000 matches in sheet2 A1:A40000.</p>
  
  <p>I have tried several ways to do this, such as Array formula (VERY SLOW), UDF (SLOW), VBA-AutoFilter(SLOW).
  Is there any way to do this quickly?</p>
  
  <p>Can anyone help?
  Thanks a lot in advance! </p>