
LOOKUP Nth Match in Excel (Includes BONUS Content to SUM to Nth Match)
In this video, we lookup Nth match in a range in Excel. Learn more than 150 Excel functions with my Advanced Excel Formulas book https://amzn.to/3Rg87Go Excel Functions such as VLOOKUP and XLOOKUP in Excel can be used to find the first matching value or the last match. But to find Nth instance of a value is not native to those functions. In this video, we will learn the Excel formula to find the Nth matching value. This video was prompted by a question on how to sum to the nth instance of a value. I decided to expand that to also learn to lookup the Nth occurrence of a value and also to count to that specific occurrence. Some great functions help us including the INDEX function and IF function in Excel. Chapter listing 00:00 - Lookup Nth match in Excel 05:07 - Sum range to Nth instance of a value 06:51 - Count values in a dynamic range Find more great free tutorials at; https://www.computergaga.com