Return Date above the Certain "TEXT" from the "NAME" in (Excel2021)

[HKA_84]

Hello,

Good Day to you,

I've to Find the Public Holiday taken with different year for certain Name
In Sheet "Public Holiday" If I put the year next to PH 1, Example "PH 1 (2021)". it can return the value but I need match with the 'NAME"
I want to keep the PH 1 Separately from the year

Example:
Name: Mary
Search For: PH 1 (2021) - CELL (C3)&(C2)
Within: Sheet January,February,March
Return: Sheet "Public Holiday" into CELL "C5"

Example 2:
Name: Billy
Search For: PH 5 (2022) - CELL (G11)&(C10)
Within: Sheet January,February,March
Return: Sheet "Public Holiday" into CELL "G12"

Public Holiday

Example.xlsx
	A	B	C	D	E	F	G	H	I
1
2			2021
3			PH 1	PH 2 (2021)	PH 3	PH 4	PH 5	PH 6
4		Billy		January 13, 2022
5		Mary
6		Kate
7		Sebastian
8		Jack
9
10			2022
11			PH 1	PH 2	PH 3	PH 4	PH 5	PH 6
12		Billy	January 10, 2022
13		Mary
14		Kate
15		Sebastian
16		Jack
17
Public Holiday

Cell Formulas
Range	Formula
D4,C12:D12	D4	=IF(COUNTIF(January!$C$4:$I$12,D3),MIN(IF(January!$C$4:$I$12=D3,January!$C$3:$I$3,"")),"")

January

Example.xlsx
	A	B	C	D	E	F	G	H	I	J
1
2	WEEK 1
3			10-Jan-22	11-Jan-22	12-Jan-22	13-Jan-22	14-Jan-22	15-Jan-22	16-Jan-22
4			Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
5		Billy	PH 1	10am	10am	PH 2 (2021)	1pm	1pm	OFF
6		Mary	1pm	PH11 (2021)	1pm	PH 12 (2021)	10am	OFF	10am
7
8	WEEK 2
9			17-Jan-22	18-Jan-22	19-Jan-22	20-Jan-22	21-Jan-22	22-Jan-22	23-Jan-22
10			Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
11		Billy	PH 3 (2022)	10am	10am	PH 4 (2022)	1pm	1pm	OFF
12		Mary	1pm	PH 1 (2022)	1pm	PH 2 (2022)	10am	OFF	10am
13
January

February

Example.xlsx
	A	B	C	D	E	F	G	H	I	J
1
2	WEEK 1
3			2-Feb-22	3-Feb-22	4-Feb-22	5-Feb-22	6-Feb-22	7-Feb-22	8-Feb-22
4			Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
5		Billy	10am	PH5 (2022)	10am	10am	1pm	1pm	PH6 (2022)
6		Mary	1pm	PH 3 (2022)	1pm	1pm	PH 4 (2022)	OFF	10am
7
8	WEEK 2
9			9-Feb-22	10-Feb-22	11-Feb-22	12-Feb-22	13-Feb-22	14-Feb-22	15-Feb-22
10			Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
11		Billy	10am	PH7 (2022)	10am	10am	1pm	1pm	PH8 (2022)
12		Mary	1pm	PH 5 (2022)	1pm	1pm	PH 6 (2022)	OFF	10am
13
February

March

Example.xlsx
	A	B	C	D	E	F	G	H	I	J
1
2	WEEK 1
3			15-Mar-22	16-Mar-22	17-Mar-22	18-Mar-22	19-Mar-22	20-Mar-22	21-Mar-22
4			Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
5		Billy	PH 9 (2022)	10am	10am	PH10 (2022)	1pm	1pm	OFF
6		Mary	1pm	PH7 (2022)	1pm	PH 8 (2022)	10am	OFF	10am
7
March

Please help me with this
I hope I made the question right to understand
Thank you very much