index/match to show high number to low number

[njlevi49]

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

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>

 

[njlevi49]

This worked Thanks I have another simular sheet that requires ranking but it would be ranked from 9 to 1 High to low but it has to add up to 45. I am not sure how to do that when I have ties (see below) Row 1 and 2 would be 8.5 each The end result would to total 45

	A	B	C
1	Friedrichs, Reid	34	9
2	Patterson, Pat	34	8
3	Grodzicki, Matt	37	7
4	Campau, Chad	36	6
5	Dougherty Jack	38	5
6	Dattilo, Mike	38	4
7	Dennis, Brad	38	3
8	Hanlon, Ed	39	2
9	Fitch, Mark	40	1
			45

<colgroup><col style="width: 19pt; mso-width-source: userset; mso-width-alt: 711;" width="25"> <col style="width: 60pt;" span="3" width="80"> <tbody>
</tbody>

 

[meldoc]

Hi

I'm not sure I understand what you are asking, could you post some data showing before and after examples.
Also what version of Excel are you using, you seem to be using RANK.AVG, and in the example that you posted the results you show in B3:B4 don't match those in C3:C4.