I have a spreadsheet with multiple tabs. On one, I have where players indicate if they'll be attending a game on a particular date, and on the other I want to populate a list of who has rsvp'd "yes" to that game. I have a dropdown where the date can be selected. I want the array formula to choose the column based on the date selected so it's more user friendly and I don't need to change the formula each time, I can just select the date. I've also tried with the attendance sheet converted to a table, but still can't get it to work. Attendance tab Line-up tab

I have a spreadsheet with multiple tabs. On one, I have where players indicate if they'll be attending a game on a particular date, and on the other I want to populate a list of who has rsvp'd "yes" to that game. I have a dropdown where the date can be selected. I want the array formula to choose the column based on the date selected so it's more user friendly and I don't need to change the formula each time, I can just select the date. I've also tried with the attendance sheet converted to a table, but still can't get it to work. Attendance tab Line-up tab

• google-sheets
• google-sheets-formula
• array-formulas

• 2 Please see stackoverflow/help/how-to-ask – Michal Commented yesterday
• 1 "I don't need to change the formula each time" <-- Any formula or sample data we can use to replicate your use case? – p._phidot_ Commented yesterday
• 3 What is your question? – P.b Commented yesterday
• 2 ARRAYFORMULA is for Google Sheets, not Excel. Please, use the right tags. – Foxfire And Burns And Burns Commented yesterday

1 Answer 1

This is one approach of the issue. Your example is in GoogleSheets adapt to it if needed.
Adjust the formula to your actual ranges

The formula in C4 cell

=FILTER(G3:G14,BYROW((H3:K14="Yes")*(H2:K2=D2),LAMBDA(x,SUM(x))))