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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!