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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!