Find the 2nd match (or nth match) using XLOOKUP - ExcelKid
![Find the 2nd match (or nth match) using XLOOKUP - ExcelKid](http://excelkid.com/wp-content/uploads/2022/08/find-the-5th-match-in-a-range.png)
This guide will explain how to find the 2nd match or the nth occurrence in an array using the XLOOKUP function.
![](https://excelkid.com/wp-content/uploads/2022/08/find-the-2nd-match-using-xlookup.png)
Find the 2nd match (or nth match) using XLOOKUP - ExcelKid
![](https://careerfoundry.com/en/wp-content/uploads/old-blog-uploads/example-xlookup-formula.png)
How To Use the XLOOKUP Function in Excel [Step-by-Step]
![](http://excelkid.com/wp-content/uploads/2022/08/index-and-match-performs-two-way-lookup.png)
Nested XLOOKUP - How to use two-way lookups
Help - Find the 2nd match using Xlookup - Microsoft Community Hub
![](https://exceljet.net/sites/default/files/styles/original_with_watermark/public/images/formulas/XLOOKUP%20last%20match.png)
XLOOKUP last match - Excel formula
![](http://excelkid.com/wp-content/uploads/2022/08/Get-the-2nd-3rd-or-nth-match-for-multiple-lookup-values.png)
Find the 2nd match (or nth match) using XLOOKUP - ExcelKid
![](https://cdn.ablebits.com/_img-blog/xlookup/xlookup-multiple-conditions.webp)
Excel XLOOKUP function with formula examples
![](https://spreadsheetweb.com/wp-content/uploads/2020/10/How-to-find-nth-closest-match-in-Excel-02i.png)
Excel Tips & Tricks How to find nth closest match in Excel
![](https://cdn.ablebits.com/_img-blog/xlookup/two-way-xlookup.webp)
Excel XLOOKUP function with formula examples
![](https://cdn-adclh.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/images/optimized/rev-2569367/trumpexcel.com/wp-content/uploads/2020/02/XLOOKUP-Formula-to-wildcard-lookup.png)
Excel XLOOKUP Function: All You Need to Know (10 Examples)
![](https://www.automateexcel.com/excel/wp-content/uploads/2022/05/17-reasons-why-xlookup-is-not-working.png)
17 Reasons Why Your XLOOKUP is Not Working - Automate Excel
![](https://excelchamps.com/wp-content/uploads/2017/05/no-change-in-value-with-vlookup-and-match-on-enter-new-column.gif)
How to use VLOOKUP MATCH Combination in Excel [LOOKUP Formula]