I need an alternative VLookup

Hi All,


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 


Please help

By: Amy

Leave a Reply

Your email address will not be published. Required fields are marked *