Making a formula that by inputting a recipe, it gives the list of ingredients?

[Teeaamzz]

Basically, I have several recipes and I would like to make it so if someone inserts a recipe code/name, it will "look up" and output the list of ingredients. Does anyone have ideas on how I can do this?

 

[Roxxien]

Re: Need help making a formula that by inputting a recipe, it gives the list of ingredients?

From what i don't see, i had say a VLOOKUP formula or INDEX/MATCH combination.

It will really help to have a sample of your exact problem to help correctly.

 

[Teeaamzz]

Re: Need help making a formula that by inputting a recipe, it gives the list of ingredients?

From what i don't see, i had say a VLOOKUP formula or INDEX/MATCH combination.

It will really help to have a sample of your exact problem to help correctly.

Hey. So I have like 5 recipes (recipe 1,recipe 2, recipe 3, etc.). Each recipe has multiple ingredients so for recipe 1 it could be A, B, C, D, E, F, G, H. That's 8 ingredients. This is a theoretical version of my problem but I should be able to do it if I understand the theoretical version

 

[Roxxien]

Re: Need help making a formula that by inputting a recipe, it gives the list of ingredients?

Let say your 5 recipes or in the sheet1 with the name/code in column A and other column contain all ingredient.

In that case, you can use sheet2 to do your search and see all the ingredient

In a specific cell, you will need to write the name/code wit the good syntax (let's say B2)

Then at the cell you want to see the first ingredient you will need VLOOKUP(B2,Sheet1!$A$1:$I$5,2,TRUE)

For the second ingredient VLOOKUP(B2,Sheet1!$A$1:$I$5,3,TRUE)

And so on ...

If you don't want to complicate yourself, this could work perfectly for you.

 

[Teeaamzz]

Re: Need help making a formula that by inputting a recipe, it gives the list of ingredients?

Hey. Thanks very much for the explanation. Have a good day :D