RJB: Name Associated With Lowest Number

[Aladin Akyurek]

In C23 enter & copy across:

=IF(C22=1,INDEX($A$9:$A$19,MATCH(C21,C9:C19,0)),"")

See...

Book5
	A	B	C	D	E	F	G	H	I
9	NameA		4	4	4	5	5	7	3
10	NameB		5	2	4	8	5	3	2
11	NameC		4	3	3	5	4	2	1
12	NameD		5	3	4	6	5	4	2
13	NameE		5	1	4	6	4	4	2
14	NameF		5	2	4	4	4	2	2
15	NameG		4	0	5	8	4	4	2
16	NameH		3	2	6	8	5	4	2
17	NameI		4	2	7	6	7	4	3
18	NameJ		3	2	7	5	5	5	3
19	NameK		4	5	4	5	7	4	3
20
21	LowestNo.		3	0	3	4	4	2	1
22	No.OfMatches		2	1	1	1	4	2	1
23				NameG	NameC	NameF			NameC
Sheet1