I have a Master Tab Showing (the table has 1000 records)

BU_CD CY_CD Cntry_CD Att_1 Att_2 Att_3 Att_4
A01 SOC UK XX1 YY1 ZZ1 XY1
A02 SHL NL XX2 YY2 ZZ2 XY2
A03 BPC IR XX3 YY3 ZZ3 XY3
A04 IOC UK XX4 YY4 ZZ4 XY4

I have another tab showing month transactions that has 40000 rows and 60
Columns of information, pulled out from the ERP system. This ERP info has
BU_CD, CY_CD and Country_CD. Using these three combination keys, I have to
populate Column 61 to Column 64 with Attribute_1 to Attribute_4 from the
Master Tab. I want to achieve this with VB as the Index & Match function
(array) takes its own sweet time to complete and sometimes Excel gets
frustrated and returns a message €œNot responding€� I am not for using
Vlookup as it would require altering table structure.

Any help is appreciated