INDEX MATCH Return Multiple Values
Sometimes one lookup value should return every matching row, not just the first one. In modern Excel, FILTER is usually the better answer than forcing INDEX MATCH to spill results. This guide shows how to return multiple orders for one customer.
Formula Syntax
Use this base syntax for index match return multiple values and replace the ranges with your own spreadsheet columns.
FILTER(return_range, criteria_range=criteria)Need this formula for your exact sheet?
Generate a custom index match return multiple values formula with your own columns, criteria, and spreadsheet layout.
Step-by-step Example
A plan administration spreadsheet tracks Orders by customer and needs a formula-driven result instead of manual filtering.
| Customer | Order ID |
|---|---|
| Acme | O-1001 |
| Beta Co | O-1002 |
| Acme | O-1003 |
Resulting formula
=FILTER(B:B,A:A="Acme")The formula evaluates the Orders by customer rows and returns O-1001, O-1003. Replace the sample ranges with your actual columns, then adjust the criteria so the result matches your workbook.
Try It Now
The generator is pre-filled for index match return multiple values. Edit the prompt to match your columns, criteria, and spreadsheet layout.
Generated formula
How it works
Need more formulas every day?
HelpFormula Pro is $7.99/mo for faster spreadsheet work across Excel and Google Sheets.
- ✓ Higher daily formula generation limits
- ✓ Saved formula history for reuse
- ✓ Excel formula language selection
Common Variations
- Return all matches
- Return first match only
- Return multiple columns
FAQ
How do I set up INDEX MATCH Return Multiple Values for Orders by customer?
Map the sample columns to your own sheet first, then replace the formula ranges with the real ranges from your workbook. Keep text criteria in quotes and verify that date or number columns are stored as real values.
Can this formula handle return all matches?
Yes. Use the same formula pattern and change the criteria, helper column, or lookup value for return all matches. If the logic becomes more complex, generate a custom version with the free tool.
What should I check if the INDEX MATCH Return Multiple Values result is wrong?
Check that every referenced range covers the same rows, locked references use dollar signs where needed, and the criteria type matches the data. For this page, also confirm that the Orders by customer fields are formatted consistently.