Auto-fill

[MrsFrankieH]

Hello Everyone,

Can I get help with this problem? I would like help with an auto-formula? I’d like to input data in A1 to E1 and auto-fill the relevant data from the data from information on the right. The range is 1 to 43. I’m sorry I don’t know the Excel terminology, but I hope you understand what I’m trying to describe.

Thank you for your help in advance.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	4	0	1	3	8		Input data							0	1	2	3	4	5	6	7	8	9
2	13	19	10	12	17									19	10	11	12	13	14	15	16	17	18
3	22	28	29	21	26				Auto-fill					28	29	20	21	22	23	24	25	26	27
4	31	37	38	30	35									37	38	39	30	31	32	33	34	35	36
5	40			39													39	40	41	42	43
Sheet1

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F								N	O	P	Q	R	S	T	U	V	W
1	4	0	1	3	8									0	1	2	3	4	5	6	7	8	9
2	13	19	10	12	17									19	10	11	12	13	14	15	16	17	18
3	22	28	29	21	26									28	29	20	21	22	23	24	25	26	27
4	31	37	38	30	35									37	38	39	30	31	32	33	34	35	36
5	40			39													39	40	41	42	43
Data

Cell Formulas
Range	Formula
A2:E5	A2	=LET(f,FILTER($N$2:$W$5,$N$1:$W$1=A1),IF(f="","",f))
Dynamic array formulas.

 

[MrsFrankieH]

How about

Fluff.xlsm
	A	B	C	D	E	F								N	O	P	Q	R	S	T	U	V	W
1	4	0	1	3	8									0	1	2	3	4	5	6	7	8	9
2	13	19	10	12	17									19	10	11	12	13	14	15	16	17	18
3	22	28	29	21	26									28	29	20	21	22	23	24	25	26	27
4	31	37	38	30	35									37	38	39	30	31	32	33	34	35	36
5	40			39													39	40	41	42	43
Data

Cell Formulas
Range	Formula
A2:E5	A2	=LET(f,FILTER($N$2:$W$5,$N$1:$W$1=A1),IF(f="","",f))
Dynamic array formulas.

Hello Fluff! Great to see you again! I'll try it right now. Thank you so much!!!

 

[MrsFrankieH]

How about

Fluff.xlsm
	A	B	C	D	E	F								N	O	P	Q	R	S	T	U	V	W
1	4	0	1	3	8									0	1	2	3	4	5	6	7	8	9
2	13	19	10	12	17									19	10	11	12	13	14	15	16	17	18
3	22	28	29	21	26									28	29	20	21	22	23	24	25	26	27
4	31	37	38	30	35									37	38	39	30	31	32	33	34	35	36
5	40			39													39	40	41	42	43
Data

Cell Formulas
Range	Formula
A2:E5	A2	=LET(f,FILTER($N$2:$W$5,$N$1:$W$1=A1),IF(f="","",f))
Dynamic array formulas.

Ut oh Fluff, it didn't work. I got an error message. Would you like me to screenshot the error message?

 

[Fluff]

What was the error?

 

[MrsFrankieH]

What was the error?

Hi Fluff, here's the screenshot.

 

[MrsFrankieH]

What was the error?

Hello Fluff!! Update: It WORKS! I somehow didn't copy it right. Thank you so much for your help again!!! You ROCK as usual!!! Have a great weekend.

 

[Fluff]

Glad it's working & thanks for the feedback.