Index/Match across multiple sheets and workbooks

[nymets5485]

Good Afternoon! I work at a medical practice that is made up of 4 sites. Each site has an excel workbook that they enter daily statistics into. I am trying to create another workbook to act as a "dashboard" to display the critical data from each sites workbook. I am trying to use an index and match formula so when the dates match it will display the corresponding cell value. I think i am close but am getting a #value! error.

So when the date in J1 matches the date on the site workbook i want the corresponding number in the patient visit column to display.

This is the formula that im trying and getting the error : =INDEX('[MWR - 2023 Stats.xlsx]Jan 23:Dec 23'!$E$9:$E$31,MATCH((J1),'[MWR - 2023 Stats.xlsx]Jan 23:Dec 23'!$B$9:$B$31,0))

Happy to provide follow up info. Thanks!

 

[nymets5485]

Yeah, web based should work just fine until the update happens. I greatly appreciate the help!

 

[Fluff]

You're welcome & thanks for the feedback.