find data based on a given date and return values to a table

[bhalbach]

I have a set of data on sheet1 that I would like to look through the dates in column S and return ONLY the values to sheet2 that are >= the date I specify on sheet2 A1. There will be multiple results.

Any help would be appreciated.

 

[Peter_SSs]

Office 2016.

I was playing with Toadstool's formula

Thank you .. and for updating your profile.

 

[Peter_SSs]

The other question I had was can the results be put in a Table that expands and shrinks to accommodate the results?

I actually mis-read this earlier and thought you were talking about making the original data into a table so had the following suggestion. However, the results formula will need to be copied down as far as you might ever need, as with Toadstool's formula. The only real difference (not a great advantage) with this one is that you would not need to make any allowance for row numbers in the original data sheet if that was made into a table.

Table name here is Table1

bhalbach.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Hdr1	Hdr2	Hdr3	Hdr4	Hdr5	Hdr6	Hdr7	Hdr8	Hdr9	Hdr10	Hdr11	Hdr12	Hdr13	Hdr14	Hdr15	Hdr16	Hdr17	Hdr18	Dates	Hdr20	Hdr21
2	90	57	38	77	77	22	19	4	37	67	26	80	13	26	33	82	49	19	1/01/2020	5	7
3	30	80	38	43	8	92	99	33	52	12	88	95	93	41	48	86	10	54	3/03/2020	89	72
4	75	74	53	65	91	8	99	55	99	79	14	71	15	84	16	44	73	69	4/04/2020	29	11
5	29	37	16	97	37	36	98	44	91	79	15	27	63	16	69	99	39	8	5/05/2020	64	53
6	9	37	2	39	82	96	52	42	59	51	54	34	15	43	65	51	24	22	6/06/2020	95	74
7	34	46	54	35	31	45	88	6	54	82	24	14	26	23	11	38	90	32	7/07/2020	12	18
Sheet1

The following formula would be enetered into B2 and copied across and down.

=IFERROR(INDEX(Table1[Hdr14],AGGREGATE(15,6,(ROW(Table1[Hdr14])-ROW(Table1[#Headers]))/(Table1[[Dates]:[Dates]]>=$A$1),ROWS(B$2:B2))),"")

bhalbach.xlsm
	A	B	C	D	E	F	G	H
1	4/04/2020	Hdr14	Hdr15	Hdr16	Hdr17	Hdr18	Dates	Hdr20
2		84	16	44	73	69	4/04/2020	29
3		16	69	99	39	8	5/05/2020	64
4		43	65	51	24	22	6/06/2020	95
5		23	11	38	90	32	7/07/2020	12
6
Sheet2