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

Potatoes

Vegetables

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 *