Vlookup with multiple criteria across different sheets

[Henry_Falcon77]

Hello everyone,

I have 2 different excel sheets with 1000's of people. One sheet is called Alpha and the other Beta. I want to pull the hours worked in Column L on beta sheet and paste it to the column F in alpa sheet. Each employee has a unique id code and a code for hours. I need a vlookup formula to search by unique id,code for hours, and total hours from sheet Beta and past the hours worked on Sheet Alpha, column F, by searching for the exact unique employee it with their matching code for hours. Please see attached. Thank you in advance for your help.

V LOOKUP multipl criteria across different sheets.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	EXCEL SHEET A- HOURS ENTERED TIMESHEET ALPHA							EXCEL SHEET A- HOURS ENTERED TIMESHEET BETA
2	NAME	UNIQUE ID Employee	TYPE OF HOURS	Code for Hours	Hours Worked on Timesheet ALPHA	PULL HOURS FROM BETA		NAME	UNIQUE ID Employee	TYPE OF HOURS	Code for Hours	Hours Worked BETA
3	Mike Sharpe	240	vaca	170	25	20		Mike Sharpe	240	vaca	170	20
4	Mike Sharpe	240	sick	180	25	17		Mike Sharpe	240	sick	180	17
5	Mike Sharpe	240	overtime	130	10	14		Mike Sharpe	240	overtime	130	14
6	Mike Sharpe	240	Comp	192	10	14		Mike Sharpe	240	Comp	192	14
7	Jimmy Snuka	165	base hours	010	30	15		Jimmy Snuka	165	base hours	010	15
8	Jimmy Snuka	165	vaca	170	20	17		Jimmy Snuka	165	vaca	170	17
9	Jimmy Snuka	165	sick	180	20	18		Jimmy Snuka	165	sick	180	18
10	Hulk Hogan	125	vaca	170	25	30		Hulk Hogan	125	vaca	170	30
11	Hulk Hogan	125	sick	180	25	27		Hulk Hogan	125	sick	180	27
12	Hulk Hogan	125	comp	190	20	18		Hulk Hogan	125	comp	190	18
13	Bob Backlund	855	sick	180	30	26		Bob Backlund	855	sick	180	26
14	Bob Backlund	855	vaca	170	30	26		Bob Backlund	855	vaca	170	26
15	Bob Backlund	855	base hours	010	10	19		Bob Backlund	855	base hours	010	19
Sheet1

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Henry_Falcon77]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I am currently using Office Professional 2019 but I have office 365 as well. Thanks for the tips.

 

[Fluff]

Thanks for that.
How about

Fluff.xlsm
	A	B	C	D	E
1	NAME	UNIQUE ID Employee	TYPE OF HOURS	Code for Hours	Hours Worked BETA
2	Mike Sharpe	240	vaca	170	20
3	Mike Sharpe	240	sick	180	17
4	Mike Sharpe	240	overtime	130	14
5	Mike Sharpe	240	Comp	192	14
6	Jimmy Snuka	165	base hours	10	15
7	Jimmy Snuka	165	vaca	170	17
8	Jimmy Snuka	165	sick	180	18
9	Hulk Hogan	125	vaca	170	30
10	Hulk Hogan	125	sick	180	27
11	Hulk Hogan	125	comp	190	18
12	Bob Backlund	855	sick	180	26
13	Bob Backlund	855	vaca	170	26
14	Bob Backlund	855	base hours	10	19
Sheet2

Fluff.xlsm
	A	B	C	D	E	F
1	NAME	UNIQUE ID Employee	TYPE OF HOURS	Code for Hours	Hours Worked on Timesheet ALPHA	PULL HOURS FROM BETA
2	Mike Sharpe	240	vaca	170	25	20
3	Mike Sharpe	240	sick	180	25	17
4	Mike Sharpe	240	overtime	130	10	14
5	Mike Sharpe	240	Comp	192	10	14
6	Jimmy Snuka	165	base hours	10	30	15
7	Jimmy Snuka	165	vaca	170	20	17
8	Jimmy Snuka	165	sick	180	20	18
9	Hulk Hogan	125	vaca	170	25	30
10	Hulk Hogan	125	sick	180	25	27
11	Hulk Hogan	125	comp	190	20	18
12	Bob Backlund	855	sick	180	30	26
13	Bob Backlund	855	vaca	170	30	26
14	Bob Backlund	855	base hours	10	10	19
Sheet1

Cell Formulas
Range	Formula
F2:F14	F2	=INDEX(Sheet2!$E$2:$E$100,MATCH(B2&"|"&D2,Sheet2!$B$2:$B$100&"|"&Sheet2!$D$2:$D$100,0))
Press CTRL+SHIFT+ENTER to enter array formulas.