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...
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.