Enter Name Get Grades

Google Sheets Dropdown + FILTER to Lookup Grades (and Handling Duplicates with INDEX) This video shows how to create a dropdown in Google Sheets from a range of names so you can select a student name in a cell and use that selection to return the student’s grades. It demonstrates using the FILTER function to pull the matching row(s) of grades based on the condition that the name column equals the selected name, and explains what happens when there are multiple matching names (multiple results expanding). It also covers the “array result has not expanded because it would overwrite data” reference error, how to fix it by clearing space, and how to wrap the FILTER with INDEX to return only the first match (or a specific row/column), including why INDEX can be risky if some names don’t have multiple entries. 00:00 Setup Grades Sheet 00:10 Create Name Dropdown 00:27 Dropdown Is Just Text 01:11 Pull Grades With Filter 02:02 Handling Duplicate Names 02:39 Fix Spill Errors 03:02 Use Index For One Result 03:52 Index Pitfalls 04:09 Prefer Full Filter View 04:40 Wrap Up And Subscribe