I have a spread sheet that I created to upscale and downscale food recipes. I
have linked an €œorder page€� to individual recipes so if I want to increase or
decrease the recipe I only have to enter the amount of cases I want to
produce and it flows to each sheet. The last page I have is an inventory
page. I have used the V-lookup formula so that each individual recipe looks
at the inventory page to get its price per pound. For example =VLOOKUP (B13,
Inventory, 11, FALSE)*E13. B13 is the name of an ingredient, then it looks
at the inventory page finds the exact ingredient, then looks 11 columns over
and uses that price per pound.
I am trying to create a page that will add up all the ingredients from each
individual recipe so I can use it to order ingredients. I have used the
following =VLOOKUP (B9,'Sweet Orange Chili Mustard'! B13:E18, 4, FALSE)
this works great for one sheet, but when I try to add another sheet either by
using a , or putting the additional sheets in a () it returns a N/A. Anybody
have any ideas.