Match fails to distinguish between two identical scores

[FivestarMac]

I almost have it, but don't know how to allow for the fact that there are two Index results for Bill because Match did not find George's row. Need another term in my formulas.
JimGood golfer.xlsx

[FlameRetired]

See if this does what you want.

Please Login or Register  to view this content.

Array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Row\Col	B	C	D	E	F	G	H	I	J	K	L
1							small		row	index
2	Bill	68	75	68	74	285	269	1	2	Jim	K2 :{=INDEX($B$2:$B$10,SMALL(IF($H2=$G$2:$G$10,ROW($B$2:$B$10)-MIN(ROW($B$2:$B$10))+1),COUNTIF($J$2:$J2,$J2)))}
3	Jim	68	62	65	74	269	284	2	7	Pete	Arrray-entered in K2 and filled down.
4	Henry	74	74	69	71	288	285	3	1	Bill
5	Zeke	75	76	69	73	293	285	4	1	George
6	Bob	76	66	73	72	287	287	5	5	Bob
7	Bent	77	68	72	80	297	288	6	3	Henry
8	Pete	65	69	73	77	284	292	7	9	Oscar
9	George	69	70	70	76	285	293	8	4	Zeke
10	Oscar	70	72	71	79	292	297	9	6	Bent

[FDibbins]

Just to clarify...
MATCH/LOOKUP/H/VLOOKUP all will search for the 1st match they find - and then stop looking.
Depending on which function you use, and how you set it up, if it cant find a match, it will either return an error, or give you the next lowest answer

[newdoverman]

I am guessing that you want the golfers ranked from low to high without ties. I added a RANK column (L) with the following formula that breaks ties. This is biased in first encountered first considered.

Please Login or Register  to view this content.

Cells O2:O21 selected and this formula ARRAY ENTERED (Ctrl + Shift + Enter) This will return the names.

Please Login or Register  to view this content.

[FivestarMac]

Thanks, that works.

[FivestarMac]

Thanks, let me think that one through.