Feb 18 2022 10:29 AM - edited Feb 18 2022 10:30 AM
Hi,
I am trying to create a recipe costing spreadsheet. Currently what I have achieved is -
- An Ingredients sheet with a breakdown of each ingredient to a price per gram.
- Separate sheets that relate to different product areas (but are essentially the same format). For example, I have a bread sheet where all bread items will be costed (about 10 in total).
At the moment I have worked out how to create a drop down menu (in the bread sheet) that can draw up any one of the ingredients listed (from the ingredients sheet). What I would like to happen is that when an ingredient is selected (in the bread sheet), the price per gram of that ingredient is listed in the following column (from there I can create separate columns with recipe amounts for each ingredient, times that by price per gram, add them all together and voila, total cost of one full recipe!)
I have been using the lookup function and have managed to get it to work for individual cells (having to input a separate formula each time), but when I try to copy and paste the formula into other cells to make it work for all ingredients, I keep getting a #N/A code back.
I hope I'm making sense here, as this has had me stumped all day.
Feb 18 2022 10:43 AM