If I have a spread sheet showing employees with their metrics and I have each
metric ranked, how do I pull the top ranked employee's name out of that
spread sheet and display it in a different place in that work book.

ex.
employee qual timely abs comm
a 1 4.25 15 510 4 2.5 3 96.4
b 5 3.83 2 330 1 0 10 95.8
c 10 2.9 1 310 15 26 1 98.0

With employee names in the range A1:A10 and their rank in B1:B10...

=INDEX(A1:A10,MATCH(1,B1:B10,0))

--
Biff
Microsoft Excel MVP


"THFish" wrote in message
...
If I have a spread sheet showing employees with their metrics and I have
each
metric ranked, how do I pull the top ranked employee's name out of that
spread sheet and display it in a different place in that work book.

ex.
employee qual timely abs comm
a 1 4.25 15 510 4 2.5 3 96.4
b 5 3.83 2 330 1 0 10 95.8
c 10 2.9 1 310 15 26 1 98.0

On Oct 10, 12:10 am, THFish wrote:
If I have a spread sheet showing employees with their metrics and I have each
metric ranked, how do I pull the top ranked employee's name out of that
spread sheet and display it in a different place in that work book.

ex.
employee qual timely abs comm
a 1 4.25 15 510 4 2.5 3 96.4
b 5 3.83 2 330 1 0 10 95.8
c 10 2.9 1 310 15 26 1 98.0

Index/Match. Try something like this. This is assuming that your
employees are in column A and the rank is in column B.
=INDEX(A2:A4,MATCH(1,B2:B4,0))

You can then use this type of formula to return the ranks for all of
the information.
=INDEX(A2:A4,MATCH(1,D2:D4,0))
=INDEX(A2:A4,MATCH(1,E2:E4,0))
etc
etc

THANK YOU GENTLEMAN, YOU GUYS ARE AWESOME

"JW" wrote:

On Oct 10, 12:10 am, THFish wrote:
If I have a spread sheet showing employees with their metrics and I have each
metric ranked, how do I pull the top ranked employee's name out of that
spread sheet and display it in a different place in that work book.

ex.
employee qual timely abs comm
a 1 4.25 15 510 4 2.5 3 96.4
b 5 3.83 2 330 1 0 10 95.8
c 10 2.9 1 310 15 26 1 98.0

Index/Match. Try something like this. This is assuming that your
employees are in column A and the rank is in column B.
=INDEX(A2:A4,MATCH(1,B2:B4,0))

You can then use this type of formula to return the ranks for all of
the information.
=INDEX(A2:A4,MATCH(1,D2:D4,0))
=INDEX(A2:A4,MATCH(1,E2:E4,0))
etc
etc