Forum Discussion
Recipe costing spreadsheet
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 tha...
wow, really hard without seeing the sheet. a couple things to check is that the references are still valid after moving/copying the formula. For example if the reference is A1:A5 and you copy that from B5 to B4 the new range will try to look at A0:A4 which is invalid. You need to use the $ to 'lock' the value A$1:A$5 would lock rows 1 - 5 but if you copy from B5 to C5 would allow the Col to change from A to B. If you use $A$1:$A$5 will lock both col and rows.
Also check if a value is not found in the lookup. If you use XLOOKUP instead you can insert a if_not_found value but if you don't have Excel365 then you might need to use IFERROR(..., "alt value").
otherwise maybe attach the sheet or give a link to it
Also check if a value is not found in the lookup. If you use XLOOKUP instead you can insert a if_not_found value but if you don't have Excel365 then you might need to use IFERROR(..., "alt value").
otherwise maybe attach the sheet or give a link to it