Help With formula

[VinceF]

Help with formula to achieve desired result

VinceF
Win10
Office 2016

UNDER CONSTRUCTION CAM BOWLING MASTER TEMPLET.xlsm
	B	C	D	E	F	G	H	I
1
2	PLAYERS	ELIM				RESULT
3	NAME	YES /NO		ELIMINATOR		ELIMINATOR
4	JOE	NO				MIKE
5	MIKE	YES				BOB
6	BOB	YES				VINCE
7	VINCE	YES				PETE
8	SAM	NO				JEFF
9	ED	NO				STEVE
10	PETE	YES				JIM
11	JEFF	YES				RON
12	ERIC	NO				COOP
13	MARK	NO				DAVE
14	STEVE	YES				JAMES
15	JIM	YES				TYLOR
16	BRENT	NO				FRANK
17	ART	NO
18	RON	YES
19	COOP	YES
20	JACK	NO
21	GARY	NO		Formula to: If column C = "YES", then
22	DAVE	YES		populate column E with corresponding players name
23	JAMES	YES
24	TIM	NO
25	KELLY	NO
26	TYLOR	YES		Column G is what it should look like
27	DREW	NO
28	FRANK	YES
Sheet1

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G
1
2		PLAYERS	ELIM				RESULT
3		NAME	YES /NO		ELIMINATOR		ELIMINATOR
4		JOE	NO		MIKE		MIKE
5		MIKE	YES		BOB		BOB
6		BOB	YES		VINCE		VINCE
7		VINCE	YES		PETE		PETE
8		SAM	NO		JEFF		JEFF
9		ED	NO		STEVE		STEVE
10		PETE	YES		JIM		JIM
11		JEFF	YES		RON		RON
12		ERIC	NO		COOP		COOP
13		MARK	NO		DAVE		DAVE
14		STEVE	YES		JAMES		JAMES
15		JIM	YES		TYLOR		TYLOR
16		BRENT	NO		FRANK		FRANK
17		ART	NO
18		RON	YES
19		COOP	YES
20		JACK	NO
21		GARY	NO
22		DAVE	YES
23		JAMES	YES
24		TIM	NO
25		KELLY	NO
26		TYLOR	YES
27		DREW	NO
28		FRANK	YES
29
Sheet6

Cell Formulas
Range	Formula
E4:E20	E4	=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($B$4:$B$30)/($C$4:$C$30="yes"),ROWS(E$4:E4))),"")

 

[Peter_SSs]

Try this
(Edit: Oops - a bit slow )

23 12 07.xlsm
	B	C	D	E
1
2	PLAYERS	ELIM
3	NAME	YES /NO		ELIMINATOR
4	JOE	NO		MIKE
5	MIKE	YES		BOB
6	BOB	YES		VINCE
7	VINCE	YES		PETE
8	SAM	NO		JEFF
9	ED	NO		STEVE
10	PETE	YES		JIM
11	JEFF	YES		RON
12	ERIC	NO		COOP
13	MARK	NO		DAVE
14	STEVE	YES		JAMES
15	JIM	YES		TYLOR
16	BRENT	NO		FRANK
17	ART	NO
18	RON	YES
19	COOP	YES
20	JACK	NO
21	GARY	NO
22	DAVE	YES
23	JAMES	YES
24	TIM	NO
25	KELLY	NO
26	TYLOR	YES
27	DREW	NO
28	FRANK	YES
List

Cell Formulas
Range	Formula
E4:E28	E4	=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW(B$4:B$28)/(C$4:C$28="Yes"),ROWS(E$4:E4))),"")

 

[VinceF]

Peter....Thank you so much, it worked perfectly...!!!

VinceF

 

[Peter_SSs]

Peter....Thank you so much, it worked perfectly...!!!

You're welcome. Glad we could help.
However, I have changed the marked solution to @Fluff's post since it is the same formula and was posted before mine.