Forum Discussion
Populate a list based on criteria in sheet 2
Hi, this is probably pretty simple but I'm not very versed in Excel. In Sheet 2 (2nd screenshot) I have a list of games and then 2 columns with criteria. I'd like to have a "selector" that populates a list in Sheet 1 Column D based on the 2 dropdowns I choose in Sheet 1 Column B (screenshot 1). Thank you!
In D2 on the first sheet:
=FILTER('Sheet 2'!A2:A1000, ('Sheet 2'!B2:B1000=B2)*('Sheet 2'!C2:C1000=B3), "")
Change Sheet 2 to the real name of that sheet.
The formula result will spill to as many rows as needed.
