Using IF and Index Match Match in single statement

[rhonllanders]

Hi!
I've been stuck on this one for a hot minute and all approaches are a #SPILL!
I'm trying to get a formula to pull in data from another file's table where Key = Yes and section of data values match both column header name and the row unique ID number.
Can you see what I'm doing wrong here?

=IF('Dashboard.xlsx'!Data[Key (Yes/No)]="Yes",IF(INDEX('Dashboard.xlsx'!Data[[Missing]:[Misaligned]], MATCH($C4,'Dashboard.xlsx'!Data[Unique ID])),MATCH(J$1, 'Dashboard.xlsx'!Data[[#Headers],[Missing]:[Misaligned]], 0)),"-")

Any help is always appreciated!

 

[KRice]

I'm guessing somewhat, but have a look:

Dashboard.xlsx
	A	B	C	D	E	F
1	Unique ID	Key (Yes/No)	Missing	Next	Misaligned	Last
2	11	Yes	1	7	13	19
3	22	Yes	2	8	14	20
4	33	No	3	9	15	21
5	44	No	4	10	16	22
6	11	Yes	5	11	17	23
7	11	No	6	12	18	24
Sheet1

Book3
	A	B	C							J
1	1									Missing
2	5									Heading Name
3			Unique ID
4			11
Sheet4

Cell Formulas
Range	Formula
A1:A2	A1	=FILTER(FILTER(Dashboard.xlsx!Data[[Missing]:[Misaligned]],(Dashboard.xlsx!Data[Key (Yes/No)]="Yes")*(Dashboard.xlsx!Data[Unique ID]=$C4)),(Dashboard.xlsx!Data[[#Headers],[Missing]:[Misaligned]]=J$1))
Dynamic array formulas.