INDEX + SMALL + IF (nth match, array formula) Function in Excel: Syntax, Examples and Free Practice
INDEX + SMALL + IF (nth match, array formula) is an Excel Lookup & Reference function. An advanced array formula that returns the Nth matching result when multiple rows meet the same condition (VLOOKUP only ever returns the first).
INDEX + SMALL + IF (nth match, array formula) syntax
Arguments
return_range: Range to pull results fromcriteria_range: Range to testn: Which match to return — 1st, 2nd, 3rd...
When to use INDEX + SMALL + IF (nth match, array formula)
Pulling the SECOND order placed by a repeat customer, not just their first one.
Practice INDEX + SMALL + IF (nth match, array formula) online, free
Open the live Excel-style spreadsheet and try INDEX + SMALL + IF (nth match, array formula) yourself. No Excel install or sign-up needed to start.
Practice INDEX + SMALL + IF (nth match, array formula) now →More Lookup & Reference functions
Frequently asked questions
What does the INDEX + SMALL + IF (nth match, array formula) function do in Excel?
An advanced array formula that returns the Nth matching result when multiple rows meet the same condition (VLOOKUP only ever returns the first).
What is the syntax of INDEX + SMALL + IF (nth match, array formula) in Excel?
The syntax is =INDEX(return_range, SMALL(IF(criteria_range=criteria, ROW(criteria_range)-ROW(criteria_range.Cells(1))+1), n)). return_range: Range to pull results from; criteria_range: Range to test; n: Which match to return — 1st, 2nd, 3rd....
Where can I practice INDEX + SMALL + IF (nth match, array formula) online for free?
Open the free live spreadsheet on Cellgrids and try INDEX + SMALL + IF (nth match, array formula) yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts