Hi I am very much an amateur with excel I only really use it to build product
sheets and recipe templates. I am basically trying to do this and I can't
seem to figure it out ( I don't speak excel too well)....

I have a recipe card on sheet 2
In cell A10 I would type in an ingredient "flour"
and what I would like it to do is put my cost per/g in cell g10 which is
linked to my master price list
here is the catch I have over 300+ recipes and I don't want to manually link
all of my G cells with the master price list
I would like to copy and paste my recipes into my current template and link
corresponding words with the appropriate cell on a different sheet. Is this
possible?