vba code to index match multiple criterias and return multiple results

[mychi11]

I knew there is a way to match multiple criterias and return multiple results by using an array function. but this will slow down the sheet I was wondering if it is possible to do it using vba code.
Here is the table 1 where I need to match table 2. I will need to index match the date and text which contain OPU and below is the outcome which I am expecting.

IVF schedule.xlsm
	K					P	Q	R
1
2
3							OPU	ET
4						Sunday, 15 May 2022	LYNN
5						Saturday, 14 May 2022		STELLA
6						Friday, 13 May 2022	CINDY
7						Wednesday, 11 May 2022	LEE
8						Monday, 9 May 2022
9						Sunday, 8 May 2022
10
Schedule

Cell Formulas
Range	Formula
P4	P4	=M3+1
P5	P5	=M3
P6	P6	=M3-1
P7	P7	=M3-3
P8	P8	=M3-5
P9	P9	=M3-6

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
T29:T36,M4:P6,M8:P27,M36:P40	Cell	does not contain a blank value	text	NO

Here is the table 2. The table 2 run from A1: NA500

IVF schedule.xlsm
	DY	DZ	EA	EB	EC	ED
1	5/9/22	5/10/22	5/11/22	5/12/22	5/13/22	5/14/22
2
3
4
5				OPU- CINDY
6
7		OPU-LEE				OPU-LYNN
8
9
10
11
12						ET-STELLA
13
14
15
16
17
18
2022

Cell Formulas
Range	Formula
DY1:ED1	DY1	=DX1+1

Many thanks

 

[mychi11]

this shd be the table one and the expected outcome