Forum Discussion

Silver Contributor

Re: Linking sheets

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.

6 Replies

zanacakes98
Copper Contributor
Aug 04, 2022
Harun24HR

Thank you for your reply. I don't see the clip to attach the workbook.
- 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
    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.