Filter Array/List Question

[john62290]

Dec	Jan	Mar	Apr	May
25	25	25	25	25
30	90	100	70	50
60				30
100				90
120
150
300

Hey! I need help with a formula with a dynamic list drop-down in cell B2 that returns the values when an above month is selected. So when the month of December is selected, it fills out 25,30,60,100, etc. Then when it changes to Jan, only 25 & 90 are returned. Thanks for the help.

 

[kweaver]

What/where is the source of the data to fill?
It would also be helpful to use XL2BB to post your sample data so that someone trying to suggest a solution doesn't have to retype everything.

 

[Peter_SSs]

See if you could adapt something like this.

23 04 28.xlsm
	A	B	C	D	E	F	G
1	Jan		Dec	Jan	Mar	Apr	May
2	25		25	25	25	25	25
3	90		30	90	100	70	50
4			60				30
5			100				90
6			120
7			150
8			300
9
Filter

Cell Formulas
Range	Formula
A2:A3	A2	=LET(f,FILTER(C2:G100,C1:G1=A1),FILTER(f,f<>""))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
A1	List	=$C$1:$G$1

 

[john62290]

What/where is the source of the data to fill?
It would also be helpful to use XL2BB to post your sample data so that someone trying to suggest a solution doesn't have to retype everything.

The source is a table in another tab. Apologies, I am not familiar with XL2BB. I definitely want to make this as easy as possible.

 

[Peter_SSs]

I am not familiar with XL2BB. I definitely want to make this as easy as possible.

There is a link in my signature block below.

The source is a table in another tab.

Do you mean a formal Excel table like this?

john62290.xlsm
	A	B	C	D	E
1	Dec	Jan	Mar	Apr	May
2	25	25	25	25	25
3	30	90	100	70	50
4	60				30
5	100				90
6	120
7	150
8	300
Sheet2

john62290.xlsm
	A
1	Jan
2	25
3	90
4
Sheet1

Cell Formulas
Range	Formula
A2:A3	A2	=LET(f,FILTER(Table1,Table1[#Headers]=A1),FILTER(f,f<>""))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
A1	List	=Sheet2!$A$1:$E$1