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?

Duplicate Thread closed

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post