Formula that returns row containing a specific value from a cell

[chenmoti]

For example I have this data:

Name	Agenda	Date
John Doe	Tire Change	3/22/2023
Jane Doe	Ask Forum	3/22/2023
John Wick	Go to Continental	3/23/2023

Then I have a cell where in I can put a date then it returns each row that contains that specific date.

Input Date:

3/22/2023

Then it should return

Name	Agenda
John Doe	Tire Change
Jane Doe	Ask Forum

 

[Bill Rockenbach]

Set up a filter. See how here FILTER function - Microsoft Support

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1	Name	Agenda	Date
2	John Doe	Tire Change	22/03/2023		22/03/2023	John Doe	Tire Change
3	Jane Doe	Ask Forum	22/03/2023			Jane Doe	Ask Forum
4	John Wick	Go to Continental	23/03/2023
5
Master

Cell Formulas
Range	Formula
F2:G3	F2	=FILTER(A2:B10,C2:C10=E2)
Dynamic array formulas.