Index Function Help
I am trying to index data by date and have applied the formula to the column. The problem I am running into is the last data entry is repeating to the end of the dates I have listed for the year even though those dates have not occurred and are not even listed on the sheet I am looking to.
=INDEX({Census}, MATCH(Date@row, {Date}))
What am I doing wrong or is there an easier way to pull this data? I pulled it to a separate sheet so that I could chart it by day without extra noise. Any advice is appreciated.
Best Answer
-
Try this adjustment:
=IF(Date@row < TODAY(), INDEX({GSRIRFAdultCensus}, MATCH(Date@row, {AdmissionDate}, 0)))
Answers
-
Does anyone have a better alternative to: =IF(Date@row < TODAY(), (INDEX({GSRIRFAdultCensus}, MATCH(Date@row, {AdmissionDate}))), 0)
-
Are you able to provide some screenshots for reference?
-
This is the sheet of submissions where you can see there is no data for 11/21/23
This is the sheet where I am pulling the above data to house separately in order to chart by date and you can see that the 11/21/23 date is pulling the 11/20/23 data.
-
Try this adjustment:
=IF(Date@row < TODAY(), INDEX({GSRIRFAdultCensus}, MATCH(Date@row, {AdmissionDate}, 0)))
-
Beautiful, it worked! I was even able to take out the IF Today piece to give me a "NO MATCH" which is perfect for charting as I wanted it to show nothing vs a zero. Thank you!!
-
Happy to help. 👍️
The IF function in my formula would have output the blank instead of the error.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!