Hello,

I have got a worksheet with 18 columns which I need to update from a different using the index and match formula in excel. The problem is that I use data from SAP which seems to be extremely difficult to be read by excel. During the calculations below on the sheet I can see something like Calculating 2processor(s)) --%" and it takes about 20min for excel to update all 18 columns with 10 000 rows. Is there any way I can use vba (for example) arrays to speed up the whole process? The actual formula which I use is the following:

=IFERROR(INDEX('SAP 5 Download'!$C$7:$C$117,MATCH('SAP 5 Tracker'!D8&'SAP 5 Tracker'!E8,'SAP 5 Download'!$A$7:$A$7912&'SAP 5 Download'!$B$7:$B$7911,0)),"")
The thread is open here too
http://www.mrexcel.com/forum/excel-q...ion-macro.html