Find 2nd, 3rd or Nth value in Excel using VLOOKUP formula
How to find 2nd, 3rd or Nth value in Excel using VLOOKUP formula
When it comes to finding or looking up data in Excel, there are two amazing formulas that I generally use – VLOOKUP and INDEX (often in conjunction with the MATCH function).
However, these formulas are designed to find the first instance of the lookup value.
But what if you want to lookup the second, third, fourth or the Nth matching value.
Well, it's possible with vlookup formula by introducing helper column
In this tutorial, you will learn with example on how to look up the second or Nth value in Excel "Using Helper Column".
Using helper column, you will be able to create a unique lookup value. This can be done by appending the number of occurrence of a value in a list.
In this video, I have given example on name of people and awards won by them.
With the help of this example, you will learn how to find the first, second, or third training done by an employee using VLOOKUP formulas
Watch Episode 1 - VLookup (Basic Level) : • VLOOKUP Episode 1: Master the $ Function f...
Watch Episode 2 - VLookup [Use $ (dollar) function] : • VLOOKUP Episode 2: Lock Columns with $ Fun...
Watch Episode 3 - VLookup [Using Match Function]: • EP 03 : VLookup [Using Match Function] Lev...
Search Keywords -
How to find 2nd, 3rd or 4th value in excel using VLOOKUP
Multiple Vlookup
How to use multiple vlookup in hindi
Vlookup with IFERROR formula
VLookup
HLookup
Lookup
XLookup
V Lookup
H Lookup
Index Match
Excel full course
Advance VLookup
Excel Full course in Hindi
Advance V Lookup in excel in Hindi
VLookup in Hindi
#ExcelTips #MSExcel #Excel