Look up value

[gates1256]

Objective: provide a gross payment value based department #, pay week, name. Data all in columns My testing is only November so 2 weeks of payments. Persons home department maybe “5” but works 50% in “4” I want to return value based on those 3 criteria. Please help

Payroll 2021-2022 updated June.xlsx
	A	B	C	D		F		H	I	J
1	NAME	FILE NUMBER	POSITION ID	STATUS		WORKED IN DEPARTMENT		PAY DATE	CHECK/VOUCHER NUMBER	GROSS PAY
2	Abdelqader Mustafa, Roaa	3060	VKF003060	A-Active		5526		11/5/2021	440149	265.66
3	Abdelqader Mustafa, Roaa	3060	VKF003060	A-Active		5522		11/5/2021	440149	797.1
4	Abdelqader Mustafa, Roaa	3060	VKF003060	A-Active		5526		11/19/2021	460129	272.09
5	Abdelqader Mustafa, Roaa	3060	VKF003060	A-Active		5522		11/19/2021	460129	816.66
6	Abdus-Salaam, Akeem	2957	VKF002957	A-Active		1580		11/5/2021	440001	715
7	Abdus-Salaam, Akeem	2957	VKF002957	A-Active		1580		11/19/2021	460001	744.25
__bookmark_1

Payroll 2021-2022 updated June.xlsx
	A	B	C	D	E
2		Pay dates	Pay dates	NOVEMBER
3	BUILDING & GROUNDS 1580	11/05/21	11/19/21	ADP	expense
4	1580 (DEPARTMENT#)			0.00	0.00
5	ABDUS-SALAAM, AKEEM			0.00	0.00
6	HOTCHKISS, DAVID			0.00	0.00
7	MARINELLI, PETER 50%			0.00	0.00
8	NEAL, REGINALD			0.00	0.00
9	REID, CHARLES			0.00	0.00
Sheet5

Cell Formulas
Range	Formula
D4:D9	D4	=SUM(B4:C4)
E4:E9	E4	=D4

 

[gates1256]

this is better use of data to show someone working in two different deparments which is important.

Payroll 2021-2022 updated June.xlsx
	A	B	C	D		F		H	I	J
1	NAME	FILE NUMBER	POSITION ID	STATUS		WORKED IN DEPARTMENT		PAY DATE	CHECK/VOUCHER NUMBER	GROSS PAY
236	Marinelli, Peter	18368	VKF018368	A-Active		1599		11/5/2021	440003	1250
237	Marinelli, Peter	18368	VKF018368	A-Active		1580		11/5/2021	440003	1250
238	Marinelli, Peter	18368	VKF018368	A-Active		1599		11/19/2021	460003	1250
239	Marinelli, Peter	18368	VKF018368	A-Active		1580		11/19/2021	460003	1250
__bookmark_1