
How to Get Multiple VLOOKUP Results in Excel and Sheets
VLOOKUP returns one result? Get multiple VLOOKUP results using FILTER, QUERY, and array formulas in Google Sheets and Excel.
13 min read
Topic
Return multiple VLOOKUP results in Excel and Google Sheets using FILTER, QUERY, and INDEX/SMALL formulas.

VLOOKUP returns one result? Get multiple VLOOKUP results using FILTER, QUERY, and array formulas in Google Sheets and Excel.
Big CSV and Excel imports freeze the tab and lose work. SmoothSheet does them server-side, with a backup you can roll back to.