gypsum995
06-24-2016, 02:31 PM
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
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