Index, Match w/ Lookup

[gtd526]

Hello,
Im looking to show Teams (A2) that are >= 65% (D2), then Match the Team (F2) that Matches the given percentage (G2).
What I have is not correct. Thank you.

NBA.xlsm
	A	B	C	D	E	F	G
1	Team	W	L	W%		Teams >65% = W%
2	MIL	6	14	30%		SAC	79%
3	LAC	6	7	46%		NYK	67%
4	LAL	4.5	6.5	41%		UTA	78%
5	TOR	6	6	50%		MEM	69%
6	BOS	6	4	60%		#N/A	#N/A
7	DAL	3	3	50%		#N/A	#N/A
8	HOU	2	5	29%
9	UTA	11	5	69%
10	MIA	4	4	50%
11	OKC	2	5	29%
12	DEN	6	6	50%
13	PHI	3.5	3.5	50%
14	IND	2	6	25%
15	PHX	11	8	58%
16	NO	5	3	63%
17	POR	2	5	29%
18	SAN	1	6	14%
19	MEM	7	2	78%
20	BRK	11	8	58%
21	ORL	5	3	63%
22	SAC	4	2	67%
23	MIN	2	4	33%
24	CHI	3	5	38%
25	DET	4	3	57%
26	WAS	4	6	40%
27	NYK	5.5	1.5	79%
28	CHA	10	5	67%
29	ATL	5	5	50%
30	CLE	3	4	43%
31	GS	5	6	45%
Sheet2

Cell Formulas
Range	Formula
F2:F7	F2	=INDEX($A$2:$A$31,MATCH($G2,$D$2:$D$31,0))
G2:G7	G2	=LOOKUP(2, 1/((COUNTIF($G$2:G2,$D$2:$D$31)=0)*($D$2:$D$31>0.65)),$D$2:$D$31)

 

[jasonb75]

Is this what you want?

Book1
	A	B	C	D	E	F	G
1	Team	W	L	W%		Teams >65% = W%
2	MIL	6	14	30%		NYK	79%
3	LAC	6	7	46%		MEM	78%
4	LAL	4.5	6.5	41%		UTA	69%
5	TOR	6	6	50%		SAC	67%
6	BOS	6	4	60%		CHA	67%
7	DAL	3	3	50%
8	HOU	2	5	29%
9	UTA	11	5	69%
10	MIA	4	4	50%
11	OKC	2	5	29%
12	DEN	6	6	50%
13	PHI	3.5	3.5	50%
14	IND	2	6	25%
15	PHX	11	8	58%
16	NO	5	3	63%
17	POR	2	5	29%
18	SAN	1	6	14%
19	MEM	7	2	78%
20	BRK	11	8	58%
21	ORL	5	3	63%
22	SAC	4	2	67%
23	MIN	2	4	33%
24	CHI	3	5	38%
25	DET	4	3	57%
26	WAS	4	6	40%
27	NYK	5.5	1.5	79%
28	CHA	10	5	67%
29	ATL	5	5	50%
30	CLE	3	4	43%
31	GS	5	6	45%
Sheet3

Cell Formulas
Range	Formula
F2:F7	F2	=IFERROR(INDEX($A:$A,AGGREGATE(15,6,ROW($D$2:$D$31)/($D$2:$D$31=G2),COUNTIF(G$2:G2,G2))),"")
G2:G7	G2	=IFERROR(AGGREGATE(14,6,$D$2:$D$31/($D$2:$D$31>=65%),ROWS(G$2:G2)),"")

 

[gtd526]

Is this what you want?

Book1
	A	B	C	D	E	F	G
1	Team	W	L	W%		Teams >65% = W%
2	MIL	6	14	30%		NYK	79%
3	LAC	6	7	46%		MEM	78%
4	LAL	4.5	6.5	41%		UTA	69%
5	TOR	6	6	50%		SAC	67%
6	BOS	6	4	60%		CHA	67%
7	DAL	3	3	50%
8	HOU	2	5	29%
9	UTA	11	5	69%
10	MIA	4	4	50%
11	OKC	2	5	29%
12	DEN	6	6	50%
13	PHI	3.5	3.5	50%
14	IND	2	6	25%
15	PHX	11	8	58%
16	NO	5	3	63%
17	POR	2	5	29%
18	SAN	1	6	14%
19	MEM	7	2	78%
20	BRK	11	8	58%
21	ORL	5	3	63%
22	SAC	4	2	67%
23	MIN	2	4	33%
24	CHI	3	5	38%
25	DET	4	3	57%
26	WAS	4	6	40%
27	NYK	5.5	1.5	79%
28	CHA	10	5	67%
29	ATL	5	5	50%
30	CLE	3	4	43%
31	GS	5	6	45%
Sheet3

Cell Formulas
Range	Formula
F2:F7	F2	=IFERROR(INDEX($A:$A,AGGREGATE(15,6,ROW($D$2:$D$31)/($D$2:$D$31=G2),COUNTIF(G$2:G2,G2))),"")
G2:G7	G2	=IFERROR(AGGREGATE(14,6,$D$2:$D$31/($D$2:$D$31>=65%),ROWS(G$2:G2)),"")

Perfect. Thank you.