nymets5485
New Member
- Joined
- Jun 22, 2023
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
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!
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!