In column b I use =INDEX($E$3:$E$21,MATCH(C3,$F$3:$F$21,0)) and column c I use =LARGE($F$3:$F$21,ROW(F2)) as you see if the numbers are the same it pulls the first set of name in the e column and their are someof the name missing. I am trying to match the names in column b with numbers in column c all data pulled from columns e and f. Any ideas on how to resolve to make this work. Thanks
<colgroup><col style="width: 19pt; mso-width-source: userset; mso-width-alt: 914;" width="25"> <col style="width: 147pt; mso-width-source: userset; mso-width-alt: 7168;" width="196"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 48pt;" width="64"> <col style="width: 143pt; mso-width-source: userset; mso-width-alt: 6948;" width="190"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <tbody>
</tbody>
A | B | C | D | E | F |
1 | Team Ranking | Points | Team Ranking | Points | |
2 | 14 Milnamow/Batcheider | 18.5 | 1 Isbister/Howe | 15 | |
3 | 6 Emeott/Hahn | 18 | 2 Fitch/Poet | 7 | |
4 | 8 Budd/Rudnick | 16 | 3 Hanlon/Dougherty | 2 | |
5 | 1 Isbister/Howe | 15 | 4 Ponkey/Levi | 20 | |
6 | 18 Conway/Daughtery | 14 | 5 Raukar/Itami | 4 | |
7 | 16 Barker/Supron | 13 | 6 Emeott/Hahn | 18 | |
8 | 9 Friedrichs/Dennis | 12 | 7 Grodzicki/Campau | 6 | |
9 | 11 Patterson/Dattilo | 11 | 8 Budd/Rudnick | 16 | |
10 | 11 Patterson/Dattilo | 11 | 9 Friedrichs/Dennis | 12 | |
11 | 10 Gohl/Thompson | 10 | 10 Gohl/Thompson | 10 | |
12 | 15 Thomas/Coates | 9 | 11 Patterson/Dattilo | 11 | |
13 | 17 Curry/Karoub | 8 | 12 Grodzicki/Scott | 11 | |
14 | 2 Fitch/Poet | 7 | 13 Hiller/Mudie | 4 | |
15 | 7 Grodzicki/Campau | 6 | 14 Milnamow/Batcheider | 18.5 | |
16 | 5 Raukar/Itami | 4 | 15 Thomas/Coates | 9 | |
17 | 5 Raukar/Itami | 4 | 16 Barker/Supron | 13 | |
18 | 3 Hanlon/Dougherty | 2 | 17 Curry/Karoub | 8 | |
19 | 3 Hanlon/Dougherty | 2 | 18 Conway/Daughtery | 14 |
<colgroup><col style="width: 19pt; mso-width-source: userset; mso-width-alt: 914;" width="25"> <col style="width: 147pt; mso-width-source: userset; mso-width-alt: 7168;" width="196"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 48pt;" width="64"> <col style="width: 143pt; mso-width-source: userset; mso-width-alt: 6948;" width="190"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <tbody>
</tbody>