Find the Nth Matching Value

MATCH is a great Excel function. Unfortunately, it’s limited to returning the first instance of a matching value. XMATCH improves upon MATCH to allow returning either the first or last matching value.

What if the value you want to return is somewhere in the middle? In this video, we’ll use Excel’s LARGE and SMALL functions to build an equation that returns any instance of a match you’d like.

Thanks for watching.

🎬 YOUTUBE LINKS 🎬
————————————

⏱ TIMESTAMPS ⏱
————————————
0:00 Introduction
0:34 Outline
1:39 LARGE Equation
6:09 SMALL Equation
7:27 Wrap up