Vlookup to Return 1st, 2nd, 3rd, Nth Matches from a List in Excel

Excel File:
Excel Forum:

Two different ways to use a lookup function to return the first, second, third, or Nth value from a list in Excel. This tutorial shows you how to do the lookup using VLOOKUP() as well as the INDEX() function.

This also covers how to return the last result from a list using both the VLOOKUP() and INDEX() functions as well as tips for sorting data to return top/bottom matches for lists with duplicate lookup values.

The Vlookup function in this tutorial requires a helper column, which I show you how to setup and use.

The Index function does not require any helper column, but it is an Array formula, but, don't worry, I show you everything you need to know to use this function. :)

Enjoy!

TeachExcel.com

#vlookup,#excel,#msexcel,#microsoft,#msoffice,vlookup excel,excel course,excel tutorial,#exceltutorial,teachexcel.com,teachexcel,free excel help,index,formulas and functions,excel search,excel functions,excle formulas,