Forum Discussion

zanacakes98's avatar
zanacakes98
Copper Contributor
Aug 04, 2022

Linking sheets

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 wi...
Formulas and Functions
Harun24HR's avatar
Harun24HR
Bronze Contributor
Aug 04, 2022
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's avatar
    zanacakes98
    Copper Contributor
    Aug 04, 2022

    Harun24HR 

     

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

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Aug 04, 2022

      zanacakes98 

      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's avatar
        zanacakes98
        Copper Contributor
        Aug 05, 2022

        HansVogelaar https://www.dropbox.com/s/rp45y4ffyklam4u/Recipe%20Costs.xlsx?dl=0     

        I finally figured how to attach the link.  

        The Ingredient sheet is the master sheet with the ingredients, units and costs. The units are

        ounces.  The additional sheets are each recipe/cake.   I need to create a formula to calculate the cost for each cake.  The Brandy Carrot and Sour Cream Cocoa recipes have their ingredients listed.  Is there a formula to link the ingredients on the master list to each cake?  

         

        An example:  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. 

         

Resources