Forum Discussion
i am costing a menu but i want my excel sheet to get data from a seperate price list database
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 ...
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.