Index/Match for Repeating Values in 2007

[jetsfan23]

Hi all,

I consider myself a pretty average Excel user, but I can't for the life of me figure this out. I'm using INDEX/MATCH like so:

Table 1:
"Data"
Col A....Col I
N1.........11
N2.........10
N3.........11
N4..........8
and so on

Table 2:
"Top 5 values:" (picks top 5 values from column I in Table 1 using LARGE functions)
11....N1
11....N1 (should be N3)
10....N2
8......N4
and so on

As shown here, when there are repeat values, it will just take the first name it finds from column A. How can I edit the formula so it won't repeat the value, and will go on to the next value? Examples of the formulas I'm using in Table 2:

=INDEX(A:A,MATCH(A21,I:I,0)) - this correctly outputs "N1"
=INDEX(A:A,MATCH(A22,I:I,0)) - this outputs "N1," should be "N3"

Thanks in advance for your help!

Chris

[NBVC]

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not JUST ENTER.

[jetsfan23]

Great, thanks! That seems to work perfectly.