VLOOKUP/IF Formula Question -- What's the best way to accomplish this?
Hi all,
I'm struggling with utilizing an if statement with a lookup table in a reference sheet. I've tried a few different combinations and all return an incorrect argument error. To be honest, I'm not sure that utilizing either of these functions is my best route to take.
This is what I want to accomplish:
If the Date corresponds with the Date on the reference sheet then I want to return the number in the next column on the reference sheet for the same row that Date appears in. The purpose of this sheet is to house daily values for numerous other sources to use as a data source for a dashboard.
My reference sheet is set up the same way:
Any input if greatly appreciated!
Thank you,
Kristina
Answers
-
You're looking for some INDEX/COLLECT here.
=INDEX(COLLECT({Active Patients Per Day Range}, {Source Range}, [Source]@row, {Day Range}, [Day]@row),1)
Then replace the Range if you want to do it alike for Active Telemetry Patients.
Hope it helped!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!