Formula to match multiple things so I can get a result to tell me what I am off on.

[zone709]

Hi,

Example Sheet 1 am trying to Match column D id number with the total hours in Column H and matching the Job name in column K to Sheet2 for results.
Need to match sheet 1 to sheet 2. Sheet1 - Id in Column D then match the totals numbers and job names in E H, I L, M P, Q T, U X for a result to come back on Sheet1 in Column L.

On sheet1 in Column L I put 8 next to 20 Pacific Street as a result. This is because Sheet 1 had 16 hours in Column H with matching job Verse Sheet2 where it only has 8 hours and matching job in columns U and X. Not 16 hours. This is what I am trying to do so I know where I’m off on down my sheet.

Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​	L​
1​	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​	L​
2​	ID	LAST NAME	FIRST NAME	ID	PERIOD END DATE	GROSS PAY	HOURLY AMOUNT	HOURLY HOURS	HOURLY RATE	OVERTIME HOURS	ORG UNIT	Results Return - Pull Formula down
3​	5​	gat	Jim	5​	1/8/2023​	200.00​	200.00​	16​	125​		15 Broome St
4​	5​	gat	Jim	5​	1/8/2023​	200.00​	200.00​	16​	125​		20 Pacific Street	8​
5​	5​	gat	Jim	5​	1/8/2023​	100.00​	100.00​	8​	125​		162 Levit Ave

Sheet: Sheet1

Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​	L​	M​	N​	O​	P​	Q​	R​	S​	T​	U​	V​	W​	X​
1​	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​	L​	M​	N​	O​	P​	Q​	R​	S​	T​	U​	V​	W​	X​
2​	SNO​	Employee Name​	Trade​	ID​	MONDAY​	​	​	​	TUESDAY​	​	​	​	WEDNESDAY​	​	​	​	THURSDAY​	​	​	​	FRIDAY​	​	​	​
3​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​
4​	​	​	​	​	ST​	OT​	DT​	JOB​	ST​	OT​	DT​	JOB​	ST​	OT​	DT​	JOB​	ST​	OT​	DT​	JOB​	ST​	OT​	DT​	JOB​
5​	3​	Jim Gat	Super	5​	8.00​	​	​	162 Levit Ave​	8.00​	​	​	15 Broome St​	8.00​	​	​	15 Broome St​	8.00​	​	​	160 75th Street​	8.00​	​	​	20 Pacific Street​

Sheet: Sheet2

 

[zone709]

Sheet2 i Meant - Id in Column D then match the totals numbers and job names in E H, I L, M P, Q T, U X for a result to come back on Sheet1 in Column L.