Index Match keeps returning #REF!

The formula that I am using looks very similar to this =INDEX(DocName.xlsb!Table7[adjustments],MATCH(Table48[[#Headers],[adjustments]],DocName.xlsb!Table7[[#Headers],[adjustments]],0))


I have a master document that is pulling data from several other documents. I have a table with a column labeled adjustments on both documents and trying to find the value that is listed under that header.

Master Document:


Secondary Document:



For some reason it keeps giving me #REF! errors if I click within the formula and then click out of it. No changes are made and if I CTRL-Z it doesn't revert back to the original state.

Any ideas why it may not be working appropriately?

Post the workbooks.

Here are the workbooks that I am currently working with.

View attachment secondary.xlsb
View attachment Master.xlsb

How will the formula/workbboks differentiate David and say John?

Each person would have a different workbook with a different name. As shown in the formula it links directly to the file by name and each agent would have a different workbook with the same layout and same cell position that it would be calling from.

Is there something that I am doing wrong? Or missing within the formula?