Formula to return matching value
Hi! I'm looking for help with a formula that will return the corresponding row value in [Dan Accrual] column when the value of the [Period] column is "Y". I was thinking this should be an index/match, but I can't quite puzzle it out. I'd be thrilled to have this result in the sheet summary, and not need to utilize an additional column.
Thanks!
Best Answer

Hi @Gloria Perez@Gloria H. you should be able to reference this with this formula:
=INDEX(COLLECT([Dan Accrual]:[Dan Accrual], Period:Period, "Y"), 1)
The collect function will give you all instances where the Period is "Y", and the "1" at the end of the Index will provide the first instance. If it's an exact match and only 1 instance exists, then you will get that one.
Answers

Hi @Gloria Perez@Gloria H. you should be able to reference this with this formula:
=INDEX(COLLECT([Dan Accrual]:[Dan Accrual], Period:Period, "Y"), 1)
The collect function will give you all instances where the Period is "Y", and the "1" at the end of the Index will provide the first instance. If it's an exact match and only 1 instance exists, then you will get that one.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 213 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 450 Show & Tell
 30 Member Spotlight
 1 SmartStories
 306 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!