How to convert VLOOKUP values to text on another sheet AUTOMATICALLY

[Lady18]

My question is very similar to https://www.msofficeforums.com/excel...ipes-help.html



I'd be grateful if you'd take a look at my workbook on my Google Drive at https://docs.google.com/spreadsheets...it?usp=sharing and tell me how I can automatically get the ingredients from the dropdowns (3rd sheet) onto a 4th sheet that I can print, take to the kitchen, and see if I have all those ingredients. Thanks in advance :-)

[Pecoflyer]

Please post your sheet on the forum, so everybody can access it and eventually help. Thanks

[Lady18]

I'll try - I've never done a forum attach. Thank you :-)

[Lady18]

Menu Recipe Ingredients TESTING.xlsx

it says I have too few letters

[Pecoflyer]

Upload worked perfectly

[Pecoflyer]

And BTW do not treat other forums like " a bunch of crap" when you are not capable of reading the FAQ when you try to post a sheet.
Thx