This guide will explain how to find the 2nd match or the nth occurrence in an array using the XLOOKUP function.
Finding second to last exact match using xlookup : r/excel
How to vlookup find the first, 2nd or nth match value in Excel?
Lookup the Second, the Third, or the Nth Value in Excel
Find the 2nd match (or nth match) using XLOOKUP - ExcelKid
XLOOKUP function - Microsoft Support
Use Vlookup To Get The Nth Match - Excel Tips - MrExcel Publishing
Excel LOOKUP formula to return multiple values (all matches)
Find the 2nd match (or nth match) using XLOOKUP - ExcelKid
excel - Vlookup or Index Match a sequence of cells - 1st, 2nd, 3rd
Excel XLOOKUP function with formula examples
VLOOKUP formulas with 3 criterias : r/excel
Excel XLOOKUP function with formula examples
Lookup nth match in table using INDEX & MATCH function