Hello all,
I have been working on this linked project database through Excel and was curious if a more efficient formula could be created. My current formlua is below...
=IF($A5>0,INDEX('C:\[Example.xlsm]Sheet2'!$A5:$P5,
MATCH($A5, 'C:\[Example.xlsm]Sheet2'!$A5:$A$200000, 2),0), "")
It essentially takes the data, cell by cell, from one workbook to another. However, having thousands of rows, with range A-P having this formula in each cell, it takes over 4 minutes to process.
Any help would be appreciated! Thank you.