#REF index match

Copper Contributor

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?

2 Replies
Please post the formula.

@WME_Intern 

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.