ANmarS - Portfolio - Match_2nd3rd

Excel/VBA expert since Sep 1997 (19 years 6 months)

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)

1767 downloads | Last updated: 1/15/2014


Screen shots (3)