Show parts of a table based on a cell value via formulas

[WSBirch]

Good afternoon,
I can't for the life of me remember what it's called or how I've done it in the past.

Basically, I have a table on Sheet02 with data in columns A-Z and rows 1-a lot, but Row 1 is the header. In Column C there's dates. On Sheet01, I have a Data Validation list of Dates. I want to select a date, say 1/26/2022, from that list then somewhere on Sheet01 (where I have space to expand horizontally right and down on the sheet) show the table from Sheet02 from A-Z but only the rows with the same value as the date selected.

Is this possible? Thank you!

quick edit;
I should specify there's 2 conditions. The date selected from the list matches values in column C from the table on Sheet02 and if there's an N or Y in column F of the table from Sheet02.

 

[Toadstool]

Hi WSBirch,

It's not very pretty but does this work for you?

WSBirch.xlsx
	A	B	C	D	E	F
1	Stuff1	Stuff2	Dates Here	Stuff3	Stuff4	ColF
2	a	2	05-May-22	ed	2eda	N
3	b	3	26-Jan-22	fr	3frb	Y
4	c	4	18-Jul-22	tg	4tgc	N
5	d	5	26-Jan-22	hyu	5hyud	Y
6	e	6	27-Aug-22	uj	6uje	N
7	f	7	03-Oct-22	uj	7ujf	Y
8	g	8	26-Jan-22	juuu	8juuug	N
9	h	9	26-Jan-22	kiki	9kikih	Y
10	i	11	26-Jan-22	lle	11llei	XX
11
Sheet02

WSBirch.xlsx
	A	B	C	D	E	F	G	H	I
1	Select Date		Results	Stuff1	Stuff2	Dates Here	Stuff3	Stuff4	ColF
2	26-Jan-22			b	3	26-Jan-22	fr	3frb	Y
3				c	4	18-Jul-22	tg	4tgc	N
4				d	5	26-Jan-22	hyu	5hyud	Y
5				h	9	26-Jan-22	kiki	9kikih	Y
6
7
Sheet01

Cell Formulas
Range	Formula
D2:I7	D2	=IFERROR(INDEX(Table1,AGGREGATE(15,6,ROW(Table1[Dates Here])/((Table1[Dates Here]=$A$2)*(SEARCH(Table1[ColF],"YN"))),ROW()-ROW($D$1))-1,COLUMN()-COLUMN($C$2)),"")

Cells with Data Validation
Cell	Allow	Criteria
A2	List	1/1/2021,1/26/2022,10/3/2022,7/18/2022
B2	List	1/26/2022,10/3/2022,7/18/2022

 

[WSBirch]

That is great, thank you!

 

[Toadstool]

That is great, thank you!

You're welcome!