Dependant drop down list based on cell in another worksheet

[oblix]

Hi there
in sheet3 I have this

I am trying to create drop down lists in column c, d, g and so on based on looking up what is in columnb, matching it to column b in sheet4 and returning all items in column c that match in sheet4 . here is sheet4

:

What should the formula in the data validation be to make this work?

 

[oblix]

will this help

test.xlsm
	B	C
1
2	category	Ingredient
3	Egg	ss
4	Egg	bb
5	Breakfast Protein	A
6	Breakfast Protein	B
7	Breakfast Protein	C
8	Breakfast Protein	D
9	Breakfast Protein	E
10	Breakfast Protein	F
11	Breakfast Protein	G
12	Breakfast Protein	H
13	Breakfast Protein	I
14	Lunch Protein	1
15	Lunch Protein	2
16	Lunch Protein	3
17	Lunch Protein	4
18	Lunch Protein	5
19	Lunch Protein	6
20	Lunch Protein	7
21	Lunch Protein	8
22	Lunch Protein	9
23	Lunch Protein	10
24	Lunch Protein	11
25	Lunch Protein	12
26	Lunch Protein	13
27	Lunch Protein	14
28	Lunch Protein	15
29	Lunch Protein	16
30	Lunch Protein	17
31	Lunch Protein	18
32	Lunch Protein	19
33	Lunch Protein	20
34	Lunch Protein	21
35	Lunch Protein	22
36	Lunch Protein	23
37	Lunch Protein	24
38	Lunch Protein	25
39	Lunch Protein	26
40	Lunch Protein	27
41	Lunch Protein	28
42	Fruit	a
43	Fruit	b
44	Fruit	c
45	Fruit	d
46	Fruit	e
47	Fruit	f
48	Fruit	g
49	Fruit	h
50	Fruit	i
51	Fruit	j
52	Fruit	k
53	Fruit	l
54	ss
55	ff
Dishes

and this:

test.xlsm
	B	C	D			G			J
1		MEAL PLAN	DAY 1			DAY 2			DAY 3
2		WEEK 1	Monday			Tuesday			Wednesday
3		BREAKFAST	BREAKFAST			BREAKFAST			BREAKFAST
4	Egg		ss			Pear			Banana
5
6		Yoghurt				Yoghurt
7
8		Cereal	Puffed Rice			Muesli Plain			Rolled Oats
9
10		Porridge	Puffed Rice			Muesli Plain			Rolled Oats
11
12		Milk	Milk			Milk			Milk
13
14		Sugar	Sugar			Sugar			Sugar
15
16		Breakfast Meat 1	Boerewors			Vienna Smoked			Fish Fingers Grilled
17		Breakfast Meat Dish 1							Bacon
18		Breakfast Meat 2	Boerewors			Vienna Smoked			Fish Fingers Grilled
19		Breakfast Meat Dish 2							Bacon
20		Egg
21		Egg Dish	Egg Fried			Egg Poached			Egg Boiled
22		Cheese	Gouda						Gouda
23		Cheese Dish
24		Supplementary Item
25			Tomato and Onion Gravy			Mushrooms Fried			Onions Rings Fried
26		Brown Bread / Toast	Brown Bread / Toast			Brown Bread / Toast			Brown Bread / Toast
27		Bread Dish
28		Spread / Jam							Apricot Jam
29
30		Butter / Margarine	Margarine			Margarine			Margarine
31
32		Beverage	Tea / Coffee			Tea / Coffee			Tea / Coffee
33
34		Milk	Milk			Milk			Milk
Cycle_1_ to_7

Cell Formulas
Range	Formula
D4	D4	=IFERROR(INDEX(Ingredients, SMALL(IF(Categories=$B4, ROW(Categories)-MIN(ROW(Categories))+1), ROW(1:1))), "")

Named Ranges
Name	Refers To	Cells
Categories	=Table1[category]	D4
Ingredients	=Table1[Ingredient]	D4
'Cycle_1_ to_7'!Print_Area	='Cycle_1_ to_7'!$C$1:$X$115	D4

Cells with Data Validation
Cell	Allow	Criteria
D16	List	=IngredientsList
B4:B34	List	=Cat_list
C4	List	=OFFSET(Sheet1!$B$3, #REF!, 0, COUNTIF(Sheet1!$A$3:$A$100, B4), 1)