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?
In general it shall work if you correctly use references within the formulas. It shall look like
with closed second workbook.