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
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.