Formula to extract information from a table that matches a date

[tbrynard01]

How can I extract information from a table (column B) that matches a date in Column C - there may be more than one row with the same date and I want to pull the text from all rows

I use Excel 365

Help will be appreciated

 

[StephenCrump]

Like this perhaps:

	A	B	C	D
1	A	18 Dec 2024
2	B	19 Dec 2024
3	C	19 Dec 2024		19 Dec 2024
4	D	20 Dec 2024		B
5	E	19 Dec 2024		C
6	F	21 Dec 2024		E
Sheet1

Cell Formulas
Range	Formula
D4:D6	D4	=FILTER(A1:A6,B1:B6=D3,"N/A")
Dynamic array formulas.

 

[tbrynard01]

Like this perhaps:

	A	B	C	D
1	A	18 Dec 2024
2	B	19 Dec 2024
3	C	19 Dec 2024		19 Dec 2024
4	D	20 Dec 2024		B
5	E	19 Dec 2024		C
6	F	21 Dec 2024		E
Sheet1

Cell Formulas
Range	Formula
D4:D6	D4	=FILTER(A1:A6,B1:B6=D3,"N/A")
Dynamic array formulas.

Thank you!