Why wouldn't you just sort the data? That seems to be what you are doing.


"alext49" wrote in message
...
Hi,

I essentially want to perform a vlookup of the second (not top) lookup
value
in an array. So if I have the following data set:

1 A 100
2 B 78
3 A 63
4 C 52
5 C 49
6 B 24


...I want to turn it into this on another page:

A 100
A 63
B 78
B 24
C 52
C 49


Getting the top A to return 100 is easy--it's just a pure vlookup. But
getting it to retun the second-ranked A is harder since vlookup just looks
to
the #1 A and brings 100 again. Does anyone have any thoughts or
suggestions
for a formula (or formulas)?