Insert Name based on Rank

[DowningAir]

I have a list of names from worksheet 'Cumulative' that I'd like to put on worksheet 'Bear Trace'. I want the the names to be placed in 'Bear Trace' based upon where they ranked (Column E) from 'Cumulative'. The #1 rank will be in A2, #12 rank in A3, ect as indicated.

These rankings my change, ie. Aaron will not always be #1. I want the name of the person holding the particular ranking to be placed in that spot on 'Bear Trace'. Any help would be appreciated. Thank you.

'Bear Trace'
A
<table border="0" cellpadding="0" cellspacing="0" width="130"><col style="width: 56pt;" width="74"> <col style="width: 21pt;" span="2" width="28"> <tbody><tr style="height: 13.5pt;" height="18"> <td class="xl24" style="height: 13.5pt; width: 56pt;" height="18" width="74">
Name</td> <td class="xl25" style="width: 21pt;" width="28">

1</td> <td class="xl26" style="border-left: medium none; width: 21pt;" width="28">

2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl33" style="height: 12.75pt; border-top: medium none;" height="17"> # 1</td> <td class="xl27" style="border-top: medium none; font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> <td class="xl28" style="font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl34" style="height: 13.5pt; border-top: medium none;" height="18"> # 12</td> <td class="xl29" style="border-top: medium none; font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> <td class="xl30" style="font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl33" style="height: 12.75pt; border-top: medium none;" height="17"> # 2</td> <td class="xl27" style="border-top: medium none; font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> <td class="xl28" style="font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl34" style="height: 13.5pt; border-top: medium none;" height="18"> # 11</td> <td class="xl29" style="border-top: medium none; font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> <td class="xl30" style="font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl33" style="height: 12.75pt; border-top: medium none;" height="17"> # 3</td> <td class="xl27" style="border-top: medium none; font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> <td class="xl28" style="font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl34" style="height: 13.5pt; border-top: medium none;" height="18"> # 10</td> <td class="xl29" style="border-top: medium none; font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> <td class="xl30" style="font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl33" style="height: 12.75pt; border-top: medium none;" height="17"> # 4</td> <td class="xl27" style="border-top: medium none; font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> <td class="xl28" style="font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl34" style="height: 13.5pt; border-top: medium none;" height="18"> # 9</td> <td class="xl29" style="border-top: medium none; font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> <td class="xl30" style="font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl33" style="height: 12.75pt; border-top: medium none;" height="17"> # 5</td> <td class="xl27" style="border-top: medium none; font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> <td class="xl28" style="font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl34" style="height: 13.5pt; border-top: medium none;" height="18"> # 8</td> <td class="xl29" style="border-top: medium none; font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> <td class="xl30" style="font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl35" style="height: 12.75pt;" height="17"> # 6</td> <td class="xl31" style="font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> <td class="xl32" style="border-left: medium none; font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl34" style="height: 13.5pt; border-top: medium none;" height="18"> # 7</td> <td class="xl29" style="border-top: medium none; font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> <td class="xl30" style="font-weight: 700; background: none repeat scroll 0% 0% lime;">
</td> </tr> </tbody></table>

'Cumulative'
A B C D E
<table border="0" cellpadding="0" cellspacing="0" width="212"><col style="width: 48pt;" width="64"> <col style="width: 28pt;" span="4" width="37"> <tbody><tr style="height: 13.5pt;" height="18"> <td rowspan="2" class="xl31" style="border-bottom: 1pt solid black; height: 27pt; width: 48pt;" height="36" width="64">Name</td> <td colspan="4" class="xl30" style="border-right: 1pt solid black; border-left: medium none; width: 112pt;" width="148">
</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl33" style="height: 13.5pt; border-left: medium none;" height="18">Score</td> <td class="xl34" style="border-left: medium none;"> Hdcp.</td> <td class="xl35"> O/A</td> <td class="xl36" style="border-left: medium none;"> Rank</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; border-top: medium none;" height="17">Aaron</td> <td class="xl44" style="border-top: medium none; border-left: medium none;"> 1</td> <td class="xl45" style="border-top: medium none; border-left: medium none;"> -61</td> <td class="xl37"> -61</td> <td class="xl39" style="border-left: medium none;"> 1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">Jay</td> <td class="xl37" style="border-left: medium none;"> 2</td> <td class="xl38" style="border-left: medium none;"> -61</td> <td class="xl40" style="border-top: medium none;"> -61</td> <td class="xl39" style="border-left: medium none;"> 2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">Matt</td> <td class="xl37" style="border-left: medium none;"> 3</td> <td class="xl38" style="border-left: medium none;"> -60</td> <td class="xl40" style="border-top: medium none;"> -60</td> <td class="xl39" style="border-left: medium none;"> 3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">Johnny</td> <td class="xl37" style="border-left: medium none;"> 4</td> <td class="xl38" style="border-left: medium none;"> -59</td> <td class="xl40" style="border-top: medium none;"> -59</td> <td class="xl39" style="border-left: medium none;"> 4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">Ryan</td> <td class="xl37" style="border-left: medium none;"> 5</td> <td class="xl38" style="border-left: medium none;"> -58</td> <td class="xl40" style="border-top: medium none;"> -58</td> <td class="xl39" style="border-left: medium none;"> 5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">Zeke</td> <td class="xl37" style="border-left: medium none;"> 6</td> <td class="xl38" style="border-left: medium none;"> -57</td> <td class="xl40" style="border-top: medium none;"> -57</td> <td class="xl39" style="border-left: medium none;"> 6</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">Nate</td> <td class="xl37" style="border-left: medium none;"> 7</td> <td class="xl38" style="border-left: medium none;"> -56</td> <td class="xl40" style="border-top: medium none;"> -56</td> <td class="xl39" style="border-left: medium none;"> 7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">DJ</td> <td class="xl37" style="border-left: medium none;"> 8</td> <td class="xl38" style="border-left: medium none;"> -55</td> <td class="xl40" style="border-top: medium none;"> -55</td> <td class="xl39" style="border-left: medium none;"> 8</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">Paul</td> <td class="xl37" style="border-left: medium none;"> 9</td> <td class="xl38" style="border-left: medium none;"> -54</td> <td class="xl40" style="border-top: medium none;"> -54
</td> <td class="xl39" style="border-left: medium none;"> 9</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">Chris</td> <td class="xl37" style="border-left: medium none;"> 10</td> <td class="xl38" style="border-left: medium none;"> -53</td> <td class="xl40" style="border-top: medium none;"> -53</td> <td class="xl39" style="border-left: medium none;"> 10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">Zach</td> <td class="xl37" style="border-left: medium none;"> 11</td> <td class="xl38" style="border-left: medium none;"> -53</td> <td class="xl40" style="border-top: medium none;"> -53</td> <td class="xl39" style="border-left: medium none;"> 11</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl26" style="height: 13.5pt; border-top: medium none;" height="18">Corey</td> <td class="xl41" style="border-left: medium none;"> 12</td> <td class="xl43" style="border-left: medium none;"> -52</td> <td class="xl42" style="border-top: medium none;"> -52</td> <td class="xl46" style="border-left: medium none;"> 12</td> </tr> </tbody></table>

 

[jimrward]

why are the # numbers in the bear trace in a random order

 

[jimrward]

if you have your random numbers in column A of the Bear Trace you can use the following to pick up the names oput this in B2

=INDEX(Cumulative!$A$3:$A$14,MATCH(bear!A2,Cumulative!$E$3:$E$14,0))

and drag down

 

[DowningAir]

Worked perfectly! Thank you.

The numbers are to be grouped 1-12, 2-11, 3-10, ect. for golf teams based upon handicap. Lowest handicap paired with the highest to even out the field.

Thanks again!