Linking sheets

Question

I am creating a workbook to track food costs for each recipe. The Ingredient List is the Master Sheet that has all the ingredients and their costs used for all the recipes. Each additional sheet will have a recipe. I want to link the costs from the Ingredient List to each recipe sheet. For example, if the price for butter increases on the Ingredient List, then the butter will automatically increase in all the recipes that have butter. How do I write that formula?

Thank you,

Zana

harun24hr · Answer

It would be better if you share a sample workbook (attach a sample file to post). I assume XLOOKUP, INDEX/MATCH, VLOOKUP, FILTER all these functions should work. Without seeing samples it is hard to suggest exact formula.

zanacakes98 · Answer

Harun24HR&nbsp;&nbsp;Thank you for your reply.&nbsp; I don't see the clip to attach the workbook.

hansvogelaar · Answer

zanacakes98&nbsp;
You can upload the workbook to a cloud store such as OneDrive, Google Drive or Dropbox. Then obtain a link to the uploaded file and paste that into a reply.
Alternatively, you can send the file to Harun24HR in a private message.

zanacakes98 · Answer

HansVogelaar&nbsp;https://www.dropbox.com/s/rp45y4ffyklam4u/Recipe%20Costs.xlsx?dl=0 &nbsp; &nbsp;&nbsp;I finally figured how to attach the link. &nbsp;The Ingredient sheet is the master sheet with the ingredients, units and costs. The units areounces. &nbsp;The additional sheets are each recipe/cake. &nbsp; I need to create a formula to calculate the cost for each cake. &nbsp;The Brandy Carrot and Sour Cream Cocoa recipes have their ingredients listed. &nbsp;Is there a formula to link the ingredients on the master list to each cake? &nbsp;&nbsp;An example: &nbsp;If the cost of vanilla increases and I change it on the master sheet I want the increase to appear for every recipe that uses vanilla.&nbsp;&nbsp;

hansvogelaar · Answer

zanacakes98&nbsp;
See the attached version. I had to change some of the ingredient names to make them the same on the master sheet and the recipe sheets. For example, I split off the word "grated" from "Coconut, grated".

Forum Discussion

Linking sheets

Share

Resources