'Video thumbnail for LOOKUP Nth Match in Excel (Includes BONUS Content to SUM to Nth Match)'

LOOKUP Nth Match in Excel (Includes BONUS Content to SUM to Nth Match)

5K views Aug 20, 2023

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

#Computers & Electronics
  # Reference