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.
![](http://excelkid.com/wp-content/uploads/2022/06/vlookup-match-text-contains.png)
XLOOKUP match text contains - ExcelKid
Help - Find the 2nd match using Xlookup - Microsoft Community Hub
![](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://cdn.mos.cms.futurecdn.net/nLKNJcxRKYiDSo5Qae2sBc.png)
How to Use XLOOKUP in Excel: VLOOKUP on Steroids
![](https://sumproduct-4634.kxcdn.com/img/containers/main/news-graphics/xlookup-and-xmatch/image1.png/e774d10cbbb9450fc45efbe51abdf434.jpg)
XLOOKUP and XMATCH: Two New X-Men for Excel < Thought
![](https://support.content.office.net/en-us/media/c05e2d7d-e0dd-49a5-801c-7a5a838ce53e.jpg)
XLOOKUP function - Microsoft Support
Help - Find the 2nd match using Xlookup - Microsoft Community Hub
![](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/excel-xlookup-function-3x.png)
Excel XLOOKUP function with formula examples
![](https://careerfoundry.com/en/wp-content/uploads/2021/01/excel-xlookup-not-found.png)
How To Use the XLOOKUP Function in Excel [Step-by-Step]
![](https://careerfoundry.com/en/wp-content/uploads/2021/01/excel-xlookup-arrays.png)
How To Use the XLOOKUP Function in Excel [Step-by-Step]
![](http://excelkid.com/wp-content/uploads/2023/01/Get-nth-matching-value-with-NVLOOKUP.png)
Lookup and return the nth value using NVLOOKUP
![](https://i.ytimg.com/vi/aV5OJ2KTlq8/maxresdefault.jpg)
Excel LOOKUP formula to return multiple values (all matches)
![](https://i.ytimg.com/vi/SiGuLG8cYlg/sddefault.jpg)
Excel LOOKUP formula to return multiple values (all matches)