VLOOKUP for Multiple Values?

[Justinian]

I am trying to create a vacation planner for 2022. I have days of 2022 numbered (1 for Monday, 2 for Tuesday, etc.) as seen below:

Date	Day	Date of Request	Request #	Employee ID	Name
01/01/22	6			0015954	Smith, John
01/02/22	7			0015954	Smith, John
01/03/22	1			0015954	Smith, John
01/04/22	2			0015954	Smith, John
01/05/22	3			0015954	Smith, John
01/06/22	4			0015954	Smith, John
01/07/22	5			0015954	Smith, John

I want to use this source data to find out what the employee days off are and if the employee has a matching number in the table above, I want Excel to return "Off" (e.g. John Smith is off Sat and Sun so in the first table, so I want Excel to look at this table below, find the off days for John Smith (6 and 7), and return the word "Off" in every cell that has a matching number of 6 or 7 in Column C:

EE Number	Employee Name	New Classification	Location Code	Senority Date	Day off	Day off 2
0015954	Smith, John	Tree Trimmers	015954	01/01/21	6	7

 

[Marcelo Branco]

Maybe...

Pasta1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Date	Day	Date of Request	Request #	Employee ID	Name		EE Number	Employee Name	New Classification	Location Code	Senority Date	Day off	Day off 2
2	01/01/2022	6	Off		15954	Smith, John		15954	Smith, John	Tree Trimmers	15954	01/01/2021	6	7
3	02/01/2022	7	Off		15954	Smith, John
4	03/01/2022	1			15954	Smith, John
5	04/01/2022	2			15954	Smith, John
6	05/01/2022	3			15954	Smith, John
7	06/01/2022	4			15954	Smith, John
8	07/01/2022	5			15954	Smith, John
9
Plan1

Cell Formulas
Range	Formula
C2:C8	C2	=IF(ISNUMBER(MATCH(B2,INDEX(M$2:N$100,MATCH(E2,H$2:H$100,0),0),0)),"Off","")

M.

 

[Justinian]

I thought about INDX, MATCH, MATCH but never thought about MATCH, INDX, MATCH!

Thank you!

 

[Marcelo Branco]

You're welcome. Glad to help.

M.