Index, Match, Match

[gtd526]

Hello,
Not sure why I'm receiving this error. Any help would be great.
X4 is the error.

NFL.xlsm
	A	B	C	D	E																	V	W	X	Y	Z
2			ATS																			Dvsn	Rank2	AFC Wildcard
3	Rank	DIV	*W/L*	ATS	TEAM																			Team	SPRD	W/L
4	7	AFC		7.5	IND																	AFC	4	#REF!
5	2	AFC		-7.5	BUF																	AFC	5
6	6	NFC		4	LAR																	AFC	3
7	3	NFC		-4	SEA																	AFC	6
8	5	NFC		-9	TB																	AFC	2
9	4	NFC		9	WAS																	AFC	7
10	5	AFC		-3	BAL																			NFC Wildcard
11	4	AFC		3	TEN																			Team	SPRD	W/L
12	7	NFC		10	CHI																	NFC	4
13	2	NFC		-10	NO																	NFC	5
14	6	AFC		6.5	CLE																	NFC	3
15	3	AFC		-6.5	PIT																	NFC	6
16	Named	Named		Named																		NFC	2
17																						NFC	7
NFL Playoff Favs

Cell Formulas
Range	Formula
A4:A15	A4	=IFERROR(INDEX('Weekly Picks'!$G$4:$G$35,MATCH('NFL Playoff Favs'!$E4,'Weekly Picks'!$A$4:$A$35,0)),"")
B4:B15	B4	=IFERROR(INDEX('Weekly Picks'!$H$4:$H$35,MATCH('NFL Playoff Favs'!$E4,'Weekly Picks'!$A$4:$A$35,0)),"")
X4	X4	=INDEX(Team,MATCH($V4,DIV),MATCH($W4,Rank))
Y4:Y9	Y4	=IFERROR(LOOKUP(2,1/(Rank="WC")/(DIV="AFC")/(Team=$X4),ATS),"")
Z4:Z9	Z4	=IFERROR(LOOKUP(2,1/(Rank="WC")/(DIV="AFC")/(Team=$X4),WL),"")
Y12:Y17	Y12	=IFERROR(LOOKUP(2,1/(Rank="WC")/(DIV="NFC")/(Team=$X12),ATS),"")
Z12:Z17	Z12	=IFERROR(LOOKUP(2,1/(Rank="WC")/(DIV="NFC")/(Team=$X12),WL),"")
D4:D15	D4	=IFERROR(INDEX('Weekly Picks'!$B$4:$B$35,MATCH('NFL Playoff Favs'!$E4,'Weekly Picks'!$A$4:$A$35,0)),"")

 

[gtd526]

Hello,
Not sure why I'm receiving this error. Any help would be great.
X4 is the error.

NFL.xlsm
	A	B	C	D	E																	V	W	X	Y	Z
2			ATS																			Dvsn	Rank2	AFC Wildcard
3	Rank	DIV	*W/L*	ATS	TEAM																			Team	SPRD	W/L
4	7	AFC		7.5	IND																	AFC	4	#REF!
5	2	AFC		-7.5	BUF																	AFC	5
6	6	NFC		4	LAR																	AFC	3
7	3	NFC		-4	SEA																	AFC	6
8	5	NFC		-9	TB																	AFC	2
9	4	NFC		9	WAS																	AFC	7
10	5	AFC		-3	BAL																			NFC Wildcard
11	4	AFC		3	TEN																			Team	SPRD	W/L
12	7	NFC		10	CHI																	NFC	4
13	2	NFC		-10	NO																	NFC	5
14	6	AFC		6.5	CLE																	NFC	3
15	3	AFC		-6.5	PIT																	NFC	6
16	Named	Named		Named																		NFC	2
17																						NFC	7
NFL Playoff Favs

Cell Formulas
Range	Formula
A4:A15	A4	=IFERROR(INDEX('Weekly Picks'!$G$4:$G$35,MATCH('NFL Playoff Favs'!$E4,'Weekly Picks'!$A$4:$A$35,0)),"")
B4:B15	B4	=IFERROR(INDEX('Weekly Picks'!$H$4:$H$35,MATCH('NFL Playoff Favs'!$E4,'Weekly Picks'!$A$4:$A$35,0)),"")
X4	X4	=INDEX(Team,MATCH($V4,DIV),MATCH($W4,Rank))
Y4:Y9	Y4	=IFERROR(LOOKUP(2,1/(Rank="WC")/(DIV="AFC")/(Team=$X4),ATS),"")
Z4:Z9	Z4	=IFERROR(LOOKUP(2,1/(Rank="WC")/(DIV="AFC")/(Team=$X4),WL),"")
Y12:Y17	Y12	=IFERROR(LOOKUP(2,1/(Rank="WC")/(DIV="NFC")/(Team=$X12),ATS),"")
Z12:Z17	Z12	=IFERROR(LOOKUP(2,1/(Rank="WC")/(DIV="NFC")/(Team=$X12),WL),"")
D4:D15	D4	=IFERROR(INDEX('Weekly Picks'!$B$4:$B$35,MATCH('NFL Playoff Favs'!$E4,'Weekly Picks'!$A$4:$A$35,0)),"")

Rank and DIV are Named Ranges. Column A & B

 

[AhoyNC]

Maybe:
INDEX(TEAM,MATCH($W4&"/"&$V4,Rank&"/"&DIV,0))

 

[gtd526]

Maybe:
INDEX(TEAM,MATCH($W4&"/"&$V4,Rank&"/"&DIV,0))

I get #Value with your formula.

NFL.xlsm
	A	B	C	D	E																	V	W	X	Y	Z
3	Rank	DIV	*W/L*	ATS	TEAM																			Team	SPRD	W/L
4	7	AFC		7.5	IND																	AFC	4	#REF!
5	2	AFC		-7.5	BUF																	AFC	5	#VALUE!
6	6	NFC		4	LAR																	AFC	3
7	3	NFC		-4	SEA																	AFC	6
8	5	NFC		-9	TB																	AFC	2
9	4	NFC		9	WAS																	AFC	7
10	5	AFC		-3	BAL																			NFC Wildcard
11	4	AFC		3	TEN																			Team	SPRD	W/L
12	7	NFC		10	CHI																	NFC	4
13	2	NFC		-10	NO																	NFC	5
14	6	AFC		6.5	CLE																	NFC	3
15	3	AFC		-6.5	PIT																	NFC	6
16	Named	Named		Named																		NFC	2
NFL Playoff Favs

Cell Formulas
Range	Formula
A4:A15	A4	=IFERROR(INDEX('Weekly Picks'!$G$4:$G$35,MATCH('NFL Playoff Favs'!$E4,'Weekly Picks'!$A$4:$A$35,0)),"")
B4:B15	B4	=IFERROR(INDEX('Weekly Picks'!$H$4:$H$35,MATCH('NFL Playoff Favs'!$E4,'Weekly Picks'!$A$4:$A$35,0)),"")
C4,C14,C12,C10,C8,C6	C4	=IFERROR(INDEX('Weekly Picks'!E4:E35,MATCH(Team,'Weekly Picks'!A4:A35,0)),"")
D4:D15	D4	=IFERROR(INDEX('Weekly Picks'!$B$4:$B$35,MATCH('NFL Playoff Favs'!$E4,'Weekly Picks'!$A$4:$A$35,0)),"")
C5,C15,C13,C11,C9,C7	C5	=IFERROR(INDEX('Weekly Picks'!E4:E35,MATCH(Team,'Weekly Picks'!A4:A35,0)),"")
Y4:Y9	Y4	=IFERROR(LOOKUP(2,1/(Rank="WC")/(DIV="AFC")/(Team=$X4),ATS),"")
Z4:Z9	Z4	=IFERROR(LOOKUP(2,1/(Rank="WC")/(DIV="AFC")/(Team=$X4),WL),"")
X4	X4	=INDEX(Team,MATCH($V4,DIV),MATCH($W4,Rank))
X5	X5	=INDEX(Team,MATCH($W5&"/"&$V5,Rank&"/"&DIV,0))
Y12:Y16	Y12	=IFERROR(LOOKUP(2,1/(Rank="WC")/(DIV="NFC")/(Team=$X12),ATS),"")
Z12:Z16	Z12	=IFERROR(LOOKUP(2,1/(Rank="WC")/(DIV="NFC")/(Team=$X12),WL),"")

 

[gtd526]

Maybe:
INDEX(TEAM,MATCH($W4&"/"&$V4,Rank&"/"&DIV,0))

I plugged in your formula as an Array. And it works.
thanks for the reply.

 

[AhoyNC]

You're welcome. Sorry, I forgot to mention it as any array formula that needed to be entered with CTRL-SHIFT-ENTER.