I’m attempting to make a spreadsheet for a school at the moment.
On one tab I have the Reciepe and Ingredients
i.e. – Cottage Pie Mince Meat
On another tab I have “what to order”
What I want it to do it look up between these sheets and automatically pull through the full ingredient list when I state “Cottage Pie”
The struggle I have at the moment is the look up will only bring through the first ingredient, but ignores the others