ANmarS - Portfolio - Match_2nd3rd

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

Match_2nd3rd    Added: 10/14/2012 | Created: 10/14/2012   

A formula trick to search for an item in a list and get 2nd, 3rd, 4th, 5th and 6th item occurance found.
VLOOKUP (also MATCH and HLOOKUP) only gives you the first occurance
This formula uses the trick of searching for an item and get the row of 2nd, 3rd, etc which we then use OFFSET or ADDRESS to read an item in that row (VLOOKUP like).
Thanks to Sreeja Sasidharan for asking the question and letting me try this approach after thinking about it for few months.

Download (4.6 KB)

1846 downloads | Last updated: 1/15/2014

Screen shots (3)