Forum Discussion

null null's avatar
null null
Copper Contributor
Jun 15, 2018

Selecting Data From A Table

I have a table of recipes. The left column lists the recipe names. The column headings are the recipe ingredients. On the table line for a given recipe, the cell in the column for each ingredient wil...
BI & Data Analytics
Need Help
Arul Tresoldi's avatar
Arul Tresoldi
Iron Contributor
Jun 16, 2018
I am not at home now, so I'm from mobile. When I go back home I'll evolve the worksheet by removing the INGREDIENT CHECK sheet, inserting those formulas directly in the SELECTOR sheet, that also can be inserted in the same sheet as RESUME. This way you'll have a 2 sheets file (lighter) that needs less caring and attention to update.

Stay tuned!
null null's avatar
null null
Copper Contributor
Jun 25, 2018

I just returned from a vacation trip and I'm looking over your suggestions. Thank you for those!


I'm not looking for suggestions on formatting my information; I have that pretty well organized. I really need direction as to what functions to explore for my recipe project.  I have about 30 different recipes and about 80 different ingredients.  On a future date I may need to schedule batches of 5 different recipes.  I need a way to summarize the quantities of each of the ingredients I need on that date.

 

Each batch will be entered on its own sheet with production date, recipe number and batch quantity.  From that information the batch sheet will be populated with the ingredients needed for the recipe and the quantities of each ingredient.  I need a way to populate and sum this ingredient information on another sheet for the production date.

 

For a recent inventory I had great success using the SUMIFS function to pull data out of an inventory spreadsheet into a summary sheet.  Can you suggest other similar functions I can explore for my current project?

Resources