Im using the following formula to and am wondering if it can be used more
efficiently, or if I need something completely different.

=INDEX($A$12:$A$43,MATCH(Q12,$N$12:$N$43,0))

Data from column N is sorted from highest to lowest into column Q in my
Excel spreadsheet.

I have duplicates in column Q, so the above formula Im using isnt working
like I need it to. I need the formula to continue to the next occurrence in
column N when a duplicate is encountered and place that result from column A
into column S. I need this to continue as such as need be. I have over ten
duplicate numbers in column Q, but those duplicate numbers represent ten
different items.

For example I have this data:

1 DMWF
1 DMWF
1 DMWF
0 CC
0 CC
0 CC

However, it should look like this:

1 DMWF
1 HD
1 P (LC)
0 CC
0 LTC
0 HTOAC

Any help would be appreciated.

Thank you.