Formula to VBA( Index Match)

[tajulit]

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 60000 Data in ColumnA And More Than 1 lac In Column E & F. So it works very slow. VBA will be very helpful for me.

Thanks in Advance

[TMS]

You don't need VBA. Just create Dynamic Named Ranges for columns E and F, it will be very fast.

That said, I have just tested your formula and it's fine. I suspect the issue may be related to other formulae in your workbook. Given you have full column references in this formula, I'm guessing that's likely to be the cause of your problem