But this time, we will populate it with customer names and occurrence numbers like " John Doe1", " John Doe2", etc. The simplest way is to add a helper column to the left of the table like we did in the first example.
Suppose you have customer names in one column, the products they purchased in another, and you are looking to find the 2 nd or 3 rd product bought by a given customer. But what if there are several matches in your lookup array and you want to get the 2 nd or 3 rd instance? The task sounds quite intricate, but the solution does exist! Formula 1.
Fg ps4c a1 01 st01 how to#
How to use VLOOKUP to get 2 nd, 3 rd or n th matchĪs you already know, Excel VLOOKUP can fetch only one matching value, more precisely, it returns the first found match.