VLookup, Index, and multiple criteria
Hello all-
I am trying to return a value from one sheet on a summary sheet based on two different criteria. I have attached a couple of screen shots.
If the YMCA Name on the "Summary - Association Attendance by Committee" sheet equals the YMCA Name in the row of the "Summary - Association Grid" sheet, return the % Participation value in "Summary - Association Attendance by Committee" for the Committee listed in the "Committee" column on the "Summary-Association Grid" (such as "Membership").
For The Greenwich Family YMCA, the result would be 100%.
I am absolutely baffled and would love your help!
Answers
-
I think you can use a formula like
=INDEX({% Participation}, MATCH(YMCA@row, {YMCA}))
to get the result.
Note:
{% Participation} is referencing the % Participation value in "Summary - Association Attendance by Committee."
{YMCA} is referencing the YMCA Name value in "Summary - Association Attendance by Committee."
Please take a look at the dashboard below.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 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!