Index Match Formula to VBA

[gypsum995]

Hi,
I use this formula of Index Matching in B2 cell.
=INDEX(F:F,MATCH(TRUE,INDEX(E:E=A2,0),0))
If A2 Data Match with any cell of Column E then copy data into B2 from corresponding Cell of Column F
It works fine But I have more Than 1 lac Data in ColumnA And More Than 1.5 lac In Column E & F. So it works very slow. VBA will be very helpful for me.

Thanks in Advance

[vcoolio]

Hello Gypsum995,

Have a look at the attachment below. It is a resolution that I supplied to another Poster in another forum.

In the test work book there are three code options. See if you can adapt any to suit your similar query. In particular, try the third code assigned to the "FindMoreStuff" button. It uses AutoFilter and should work faster with a large data set. The code is in Module 3.

I hope that this helps.

Cheerio,
vcoolio.