Hello,
Here is what I am attempting to accomplish.
· Identify the bottom 5 “% Trace” (Which I think that I have done)
· Identify the “Route” associated with each “% Trace”
· Identify the “Driver” associated with each “% Trace”
Any help would be greatly appreciated.
Thanks,


Scott

Attached Files

INDEX MATCH.xlsx (13.3 KB, 10 views)

Try:

=INDEX(A$3:A$15,MATCH(M18,$M$3:$M$15,0)) copied down and to next column

If there is a possiblity of repeated %Trace values, then you might need to use this array formula:

=INDEX(A$3:A$15,SMALL(IF($M$3:$M$15=$M18,ROW($M$3: $M$15)-ROW($M$3)+1),COUNTIF($M$18:$M18,$M18)))

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down and over.

This will get the unique matches for the repeated percentages

It works! Thank you for your assistance.