Nov 01 2019 12:03 PM
Using index match to pull data from one excel file to another. After I save it random "#REFs" will pop up in the index and match formulas. Any ideas for how to fix?
Nov 04 2019 04:42 AM
In general it shall work if you correctly use references within the formulas. It shall look like
=INDEX('C:\myfolder\[Book2.xlsx]Sheet1'!$A:$A,MATCH(A1,'C:\myfolder\[Book2.xlsx]Sheet1'!$C:$C,0))
with closed second workbook.