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. 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:
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. 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:
Code:
[/FONT][/COLOR]=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)),"")[COLOR=#333333][FONT=Segoe UI]
