Transfer values using formulas only

[bluefeather8989]

Using formulas only. How do I transfer the list on the left to the list on the rite in the order of numbers in column C. If there is no value in column C then dont list it.

Example:
K3 2 L3 Shredded Lettuce M3 A1
K4 1 L4 Bread white** M4 A1
K5 4 L5 Hawaii buns M5 A7
And so on

Shopping list V.2020.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N
1					SORT
2		#	Items	Ile	Sort		A	B		#	Items	Ile
3			Carrots	A1	1		A1	1
4			Celery	A1	1		A7	2
5			Lemon juice	A1	1		A8	3
6			Onion	A1	1		A9	4
7			Potatoes	A1	1		A10	5
8		2	Shredded lettuce	A1	1		A11	6
9			Tomatoes	A1	1		A12	7
10			Bread wheat	A7	2		A13	8
11		1	Bread white **	A7	2		A14	9
12			Hamburger buns	A7	2		A15	10
13		4	Hawaii buns	A7	2		A16	11
14			Hotdog buns	A7	2		A17	12
15			Tacos shells (soft)	A7	2		A18	13
16			Butterfingers	A8	3		A19	14
17			Coffee creamer	A9	4		A20	15
18			Coffee Folgers classic roast	A9	4		A21	16
19			Lipton tea bags decaf	A9	4		A22	17
20			Peanut butter	A9	4		A23	18
21			Welches grape jelly	A9	4		A24	19
22			Garlic croutons	A10	5		A25	20
23			Hines 57	A10	5		A26	21
24		2	ketchup 2pkg	A10	5		A27	22
25		1	Mt. Olive dill pickles (long)	A10	5		A28	23
Data

Cell Formulas
Range	Formula
C3:C25	C3	=IF(D3="","",IF(INDEX(List!C:C,MATCH(D3,List!D:D,0),0)>0,INDEX(List!C:C,MATCH(D3,List!D:D,0),0),""))
F3:F25	F3	=IF(E3="","",INDEX(Data!I:I,MATCH(E3,Data!H:H,0)))

 

[bluefeather8989]

Please forgive me I just got off work and my brain isn't working any more. I can use a Simpple index match for columns K,M.Just need to get the "Items" to Column L

 

[Fluff]

Maybe

+Fluff 1.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M
1					SORT
2		#	Items	Ile	Sort		A	B		#	Items	Ile
3			Carrots	A1	1		A1	1		2	Shredded lettuce	A1
4			Celery	A1	1		A7	2		1	Bread white **	A7
5			Lemon juice	A1	1		A8	3		4	Hawaii buns	A7
6			Onion	A1	1		A9	4		2	ketchup 2pkg	A10
7			Potatoes	A1	1		A10	5		1	Mt. Olive dill pickles (long)	A10
8		2	Shredded lettuce	A1	1		A11	6
9			Tomatoes	A1	1		A12	7
10			Bread wheat	A7	2		A13	8
11		1	Bread white **	A7	2		A14	9
12			Hamburger buns	A7	2		A15	10
13		4	Hawaii buns	A7	2		A16	11
14			Hotdog buns	A7	2		A17	12
15			Tacos shells (soft)	A7	2		A18	13
16			Butterfingers	A8	3		A19	14
17			Coffee creamer	A9	4		A20	15
18			Coffee Folgers classic roast	A9	4		A21	16
19			Lipton tea bags decaf	A9	4		A22	17
20			Peanut butter	A9	4		A23	18
21			Welches grape jelly	A9	4		A24	19
22			Garlic croutons	A10	5		A25	20
23			Hines 57	A10	5		A26	21
24		2	ketchup 2pkg	A10	5		A27	22
25		1	Mt. Olive dill pickles (long)	A10	5		A28	23
Data

Cell Formulas
Range	Formula
K3:M7	K3	=FILTER(C3:E25,C3:C25<>"")
Dynamic array formulas.

 

[bluefeather8989]

Maybe

+Fluff 1.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M
1					SORT
2		#	Items	Ile	Sort		A	B		#	Items	Ile
3			Carrots	A1	1		A1	1		2	Shredded lettuce	A1
4			Celery	A1	1		A7	2		1	Bread white **	A7
5			Lemon juice	A1	1		A8	3		4	Hawaii buns	A7
6			Onion	A1	1		A9	4		2	ketchup 2pkg	A10
7			Potatoes	A1	1		A10	5		1	Mt. Olive dill pickles (long)	A10
8		2	Shredded lettuce	A1	1		A11	6
9			Tomatoes	A1	1		A12	7
10			Bread wheat	A7	2		A13	8
11		1	Bread white **	A7	2		A14	9
12			Hamburger buns	A7	2		A15	10
13		4	Hawaii buns	A7	2		A16	11
14			Hotdog buns	A7	2		A17	12
15			Tacos shells (soft)	A7	2		A18	13
16			Butterfingers	A8	3		A19	14
17			Coffee creamer	A9	4		A20	15
18			Coffee Folgers classic roast	A9	4		A21	16
19			Lipton tea bags decaf	A9	4		A22	17
20			Peanut butter	A9	4		A23	18
21			Welches grape jelly	A9	4		A24	19
22			Garlic croutons	A10	5		A25	20
23			Hines 57	A10	5		A26	21
24		2	ketchup 2pkg	A10	5		A27	22
25		1	Mt. Olive dill pickles (long)	A10	5		A28	23
Data

Cell Formulas
Range	Formula
K3:M7	K3	=FILTER(C3:E25,C3:C25<>"")
Dynamic array formulas.

Wow! That's kick azz good. Even better than I thought it would be. THANKS

 

[Fluff]

You're welcome & thanks for the feedback.

 

[bluefeather8989]

You're welcome & thanks for the feedback.

i was wondering if you could copy the "Items" in column D to column L in alphabetical order. so that if I add an item on the bottom it will automatically alphabetties .

 

[Fluff]

How about

=SORT(FILTER(C3:E25,C3:C25<>""),2)

 

[bluefeather8989]

How about

=SORT(FILTER(C3:E25,C3:C25<>""),2)

Thanks

 

[Fluff]

My pleasure.