Aug 15 2019 08:28 AM
Hi I am trying to set up a simple way to cost menus for my restaurant.
I will have all my products and prices etc in one excel sheet but my recipes in separate sheets.
How can I set it up so that if I type in lets say apples into my recipe sheet it will automatically import the data from the price list sheet
Aug 15 2019 08:46 AM
Hello @simon_knights,
It sounds like your problem could be solved with either the VLOOKUP() formula or a combination of INDEX() and MATCH() formulas.
If you share your workbook, I could look into this further for you.