Correct...there are never more than 2.

Thanks in advance...





"T. Valko" wrote:

Are there *always* no more than 2 of each value?

Biff

"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)?