Match_2nd3rd - Free
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).

http://anmars.com/Work/?P=500211128
Match_2nd3rd - Free
2
98
0
Published:

Match_2nd3rd - Free

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 gi Read More
2
98
0
Published:

Creative Fields