This is a shortened version of my post at https://www.msofficeforums.com/excel/32457-how-convert-vlookup-values-text-another-sheet.html - just for clarity.
My workbook is here
Menu Recipe Ingredients TESTING.xlsx
I want a formula(s) that will take all this data, which is subject to change, and automatically put in a nice, neat list on the "Items List" page. How can I achieve this?