how to return value with three lookup

[go14344]

i name this sheet masterlist

1	A	B	C	D 1	E 2	F 3	G 4	H 5	I 6
2			A.M.
3	ID #	Employee		7/25	7/26	7/27	7/29	7/30	7/31
4	9101	Mario Sellona		6-11	6-12	7-11	7-12	730-11	730-12
5	9301	Daisy Rose Domingo		7-12	6-12	7-11	7-12	730-11	730-12
6	9302	Alfonso Lawas		6-11	6-12	7-11	7-12	730-11	730-12

<tbody>
</tbody>

in another sheet, i name it report, how can i return the data with three lookup? i need to return the date in red font and the schedule in green font, when i encode the no. 1-6 and ID# and A.M.... thanks..

sample:

1	9101	A.M.	6-11	7/25
1	9301	A.M.	7-12	7/25
2	9101	A.M.	6-12	7/26
3	9302	A.M.	7-11	7/27
4	9302	A.M.	7-12	7/29

<tbody>
</tbody>

 

[CANCER MAN]

Hello, somewhat like this?

Excel 2013/2016
	C
12
Masterlist

 

[CANCER MAN]

Hello, somewhat like this? Can modify it Please -

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2					1	2	3	4	5	6
3					A.M.
4	3	9302	Alfonso Lawas		25-Jul	26-Jul	27-Jul	29-Jul	30-Jul	31-Jul
5	4	9101	Mario Sellona		11-Jun	12-Jun	11-Jul	12-Jul	730-11	730-12				1	9101	A.M.	6-11	25-Jul
6	5	9301	Daisy Rose Domingo		12-Jul	12-Jun	11-Jul	12-Jul	730-11	730-12				1	9301	A.M.	7-12	25-Jul
7	6	9302	Alfonso Lawas		11-Jun	12-Jun	11-Jul	12-Jul	730-11	730-12				2	9101	A.M.	6-12	26-Jul
8														3	9302	A.M.	7-11	27-Jul
9														4	9302	A.M.	7-12	29-Jul
10
11
12
13
14
15														Criteria1	1-6
16														Criteria2	ID#
17						#N/A	#N/A							Criteria3	A.M.
18						#N/A
19						#N/A
20						25-Jul-19
21						25-Jul-19
22						#N/A
23
Masterlist

Cell Formulas
Range	Formula
F17	=VLOOKUP(VLOOKUP(VLOOKUP($N5,$A$4:$B$7,2,0),$O$5:$P$9,2,),$P$5:$R$9,3,)
F18	=VLOOKUP(VLOOKUP(VLOOKUP(N6,$A$4:$B$7,2,0),$O$5:$P$9,2,),$P$5:$R$9,3,)
F19	=VLOOKUP(VLOOKUP(VLOOKUP(N7,$A$4:$B$7,2,0),$O$5:$P$9,2,),$P$5:$R$9,3,)
F20	=VLOOKUP(VLOOKUP(VLOOKUP(N8,$A$4:$B$7,2,0),$O$5:$P$9,2,),$P$5:$R$9,3,)
F21	=VLOOKUP(VLOOKUP(VLOOKUP(N9,$A$4:$B$7,2,0),$O$5:$P$9,2,),$P$5:$R$9,3,)
F22	=VLOOKUP(VLOOKUP(VLOOKUP(N10,$A$4:$B$7,2,0),$O$5:$P$9,2,),$P$5:$R$9,3,)
G17	=VLOOKUP(VLOOKUP(VLOOKUP(O5,$A$4:$B$7,2,0),$O$5:$P$9,2,),$P$5:$R$9,3,)

 

[go14344]

Hello, somewhat like this? Can modify it Please -

Excel 2013/2016

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2					1	2	3	4	5	6
3
4					25-Jul	26-Jul	27-Jul	29-Jul	30-Jul	31-Jul
5		9101	Mario Sellona		6-11	7-11	630-11	730-11
6
8		something like this:
10
11		criteria 1	criteria 2		return value 1	return value 2
12		1	9101		6-11	25-jul
13		2	9101		7-11	26-jul
14		3	9101		630-11	27-jul
15		4	9101		730-11	29-jul

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>