listing a number in a cell to display a list of items in another cell

[petonii]

When inserting "1" in the cell under soup, i was thinking it will bring up a list of its ingredients and how much of that ingredient. The values are listed in the same spread sheet below.

The amount of the ingredient is in D50 (80grams) and the item type next to it in E50(onion)
Is it possible to put in "1" soup then it displays all the items in both those cells range example(D50-E50 to D60-E60)?
Is it possible to put the value "2" in soup and it shows double the measurements? example (160grams) (onion)


sorry if this is not clear thankyou

[TKCZBW]

Could you post a screenshot of your worksheet (unfortunately, I can't download sheets from work)? It's difficuly to work out what is needed without being able to see what you already have.

[FDibbins]

Hi and welcome to the forum

I think you forgot to attach the workbook?

From the sounds of it though, you probably need to look at using VLOOKUP

@ TKCZBW we try to discourage screen shots on the forum, often they are too small to be of any use, and most members are reluctant to retype data

[petonii]

VLOOKUP - I like to teach myself, needed to be pointed in the right direction. thank you for your assistance.

[TKCZBW]

@FDibbins:

Thanks, understood!