Nested IF Statement Doesn't Work

[Patikns23]

I have a report out of our time clock that shows clock in/out times by employee and date. I have another Excel spreadsheet with EE IDs in column A and dates in row 1.

I wanted to do a lookup to the time clock report and when the EE ID and Date match, bring back the time clocked in.

I tried this nested IF statement; but, I get a #SPILL! area because the range is too big.

=IF('Employee Time by Date-Detailed Actual Times 1-01-23 through 1-23-23.xlsx'!$A:$A=A3,IF('Employee Time by Date-Detailed Actual Times 1-01-23 through 1-23-23.xlsx'!$B:$B=C1,'Employee Time by Date-Detailed Actual Times 1-01-23 through 1-23-23.xlsx'!$C:$C))

What formula can I use to get the intended result?

Thank you.

 

[Sufiyan97]

Try

Book11
	A	B	C	D	E	F	G	H
1	EE ID	EE Name	1/1/2023	1/2/2023	1/3/2023	1/4/2023	1/5/2023
2	1030		#N/A	#N/A	#N/A	#N/A	5:37:00 AM
3
Destination

Cell Formulas
Range	Formula
C2:G2	C2	=INDEX(Source!$C$3:$C$10,MATCH($A2&C$1,Source!$A$3:$A$10&Source!$B$3:$B$10,0))

 

[Patikns23]

Try

Book11
	A	B	C	D	E	F	G	H
1	EE ID	EE Name	1/1/2023	1/2/2023	1/3/2023	1/4/2023	1/5/2023
2	1030		#N/A	#N/A	#N/A	#N/A	5:37:00 AM
3
Destination

Cell Formulas
Range	Formula
C2:G2	C2	=INDEX(Source!$C$3:$C$10,MATCH($A2&C$1,Source!$A$3:$A$10&Source!$B$3:$B$10,0))

That worked! Thanks so much!

 

[Sufiyan97]

You're welcome.