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 that if I type in lets say apples into my recipe sheet it will automatically import the data from the price list sheet
2 Replies
A clean way to handle this is to keep your price list as a structured table and pull values into your recipe sheets using lookups rather than manual entry.
For example, if your price list sheet has product names, unit cost, and units, you can use XLOOKUP (or VLOOKUP in older Excel versions) to automatically return the cost when you type the ingredient name in the recipe sheet. This keeps pricing consistent and avoids duplication.
I’ve used this approach when analyzing real menu datasets where prices change frequently, and it scales well as the menu grows. Here’s a public menu structure I referenced while testing similar lookup logic as an example dataset:
https://dbrosmenu.com/The key is making sure product names are standardized across sheets so the lookup functions don’t break.
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.
