Lookup Criteria to get all matched columns with one cell Reference

[tobysimon]

Hello,

Been looking for some help, to get matched columns with one Date reference. I tried my understanding, but I only get one row values from all columns instead of multiple matched values as shown below. Would be really great if I get some help. Thank you. Note: All three sheets data starts from Row1 including headings.

 

[LegendaryAxe]

Is this what you want?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	(Source) Sheet1							(Date Reference) Sheet2		(Get results in Sheet3)
2	Date	Name	State	vle1	vle2	vle3		Date		Date	Name	State	vle1	vle2	vle3
3	9/9/2024	Jacob	TX	15	35	55		8/9/2024		8/9/2024	Steve	CT	20	40	60
4	8/9/2024	Steve	CT	20	40	60				8/9/2024	Samuel	NY	30	50	70
5	7/9/2024	Ryan	DC	25	45	65
6	8/9/2024	Samuel	NY	30	50	70
Sheet1

Cell Formulas
Range	Formula
J2:O4	J2	=VSTACK(HSTACK({"Date","Name","State","vle1","vle2","vle3"}),FILTER(A3:F6,A3:A6=H3))
Dynamic array formulas.

 

[tobysimon]

Hello,

Been looking for some help, to get matched columns with one Date reference. I tried my understanding, but I only get one row values from all columns instead of multiple matched values as shown below. Would be really great if I get some help. Thank you. Note: All three sheets data starts from Row1 including headings.

View attachment 116643

Source data is huge by rows, but columns are limited to 17. Hence I started developing VBA Macros but it only picks 1 matched row instead of all the rows that are matched. Appreciate if I could get some help.

 

[Fluff]

Is this what you want?

That won't work in 2021 as vstack & hstack are only in 365.

 

[tobysimon]

That won't work in 2021 as vstack & hstack are only in 365.

Ok, thanks for you reply. But am trying to make it work by using macros.

 

[LegendaryAxe]

That won't work in 2021 as vstack & hstack are only in 365.

Ah, gotcha. Good catch.

 

[Fluff]

In future please do not mark a post as the solution, when it does not contain one.
Thanks