VLookup, Index, and multiple criteria

Chris Pallatto

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!

jmyzk_cloudsmart_jp

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.

https://app.smartsheet.com/b/publish?EQBCT=bcce31831f404fbaa4281390190f8990