Populate cells based on category chosen

Hello Experts Please help me with the below task

The attached file has on two sheets, the first sheet named inventory list has on inventory items that will go into recipes. These inventory items are assigned to specific categories.
On the sheet named “Recipes” when I select a category from the drop down list located in cell A19:A28. I need to see all the inventory items belonging to that category in the drop down list under the heading “Recipe Inventory” located in cells D19:D28.

Example: when I select the category “chicken” in cell A19 I need to see in the drop down list in cell D19 all the inventory items belonging only to the Chicken Category so I can make my selection. After I have selected the inventory item from the drop down list, I need column ‘C’ (item Code), Column ‘E’ (Recipe Unit Price ) & Column ‘G’ (Recipe Unit) to be populated with the data for that item. All these data are found on the sheet named “Inventory list”


Thank You
Teddy

Thanks for replying. Unfortunately this is not what i want
Let me try and be clear as to what i want. When i select a category i need to see all the inventory items in the drop down box belonging to that category. It must also be in the same line.
So if i select chicken in A19 then in D19 i need to see in the drop down box,all the inventory items belonging to the chicken category so i can make my selection.

If i select another category in a next row then i need to see all items for that category in column D of the same row etc.
example if i select the category Fries in A20, then in D20 i need to see in the drop down box all the items belonging to the Fries category.

Hi Modytrane. thanks for replying.
I should tell you that any row the category is selected in then the corresponding row in column D must show you in the drop down box all the items belonging to that category. example if in cell A20 i select the category Fries then in cell D20 the drop down box must show me all the items belonging to the Fish category.
This wiil be the same scenario for each row under the inventory category (A19:A28) and D19:D28)

Experts

If i select any category in cell A19, then in D19 the drop down box must show me all the inventory items relating to that category. eg: if i select category chicken then in D19 drop down box must show me all chicken inventory items.

This principle will be the same for all rows in the Inventory category range A19 to A28
So If i select any category in cell A20 then in D20 the drop down box must show all inventory items relating to that category.

The same thing must happen for Cell A21, A22, A23, A24, A25, A26, A27 & A28

I hope i am a bit clearer

Hi Protonl,

When i select the category "Other Food" the items belonging to this category is not displayed in the Drop down box in column D

Hello Modytrane, Thanks again for replying

The problem i am having with your formula is that when i add new inventory items to any category on the Inventory list sheet and select that category on the Recipe Sheet, nothing appears in the Drop down Box for that category.

I need to be able to add new items on the Inventory list sheet and see it in the drop down box when i select that category on the Recipe Sheet

Please see if you can sort this issue out for me.

Thanks,
Teddy

Thanks Modytrane . I will test the file and be more specific.

Modytrane,

i have tested the file. Your formula work but i should have told you that i will need to copy the entire section that you have worked on (A17: H30) to different sections on the Recipe Sheet also be able to copy it to another sheet if possible. So i want to be able to use it as a Template.

That is the only issue i now have. Once this is sorted out everything will be ok. Please see example in attached file.

Any Success on this issue

Please be more clear when you say "you'll have to change the highlighted text to wherever those values are"