match each row

[adirusf]

different value	same value to match	result in one cell
05/Oct/2021	29/Apr/2022	text
29/Sep/2021	28/Sep/2021	text1
10/Oct/2021	05/Oct/2021	text2
29/Apr/2022	29/Mar/2022	text3
13/Oct/2021
11/Oct/2021
15/Dec/2021
23/Aug/2022

How to match each row from `different value` with the date from 'same value to match'. If there is a match then in one cell to result text from column 3 'result in one cell'.
For eg. from column 1 date 05/oct/2021 and 29/apr/2022 match with column 2 'same value to match' and the result should be: 'text, text3'. I tried with index and match but show only the first result. Thanks.

 

[adirusf]

Sorry for the previous post with the data.. I attached a screenshot.

 

[adirusf]

I tried with this formula
={index(E18:E21,match(C18,D18:D21,0)),index(E18:E21,match(C19,D18:D21,0)),index(E18:E21,match(C20,D18:D21,0)),index(E18:E21,match(C21,D18:D21,0))}

RESULT IS text2 #N/A #N/A text

How to eliminate #N/A from the array? to remain only with text2 and text?

Any better solution?