Home

i am costing a menu but i want my excel sheet to get data from a seperate price list database

%3CLINGO-SUB%20id%3D%22lingo-sub-806845%22%20slang%3D%22en-US%22%3Ei%20am%20costing%20a%20menu%20but%20i%20want%20my%20excel%20sheet%20to%20get%20data%20from%20a%20seperate%20price%20list%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-806845%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20am%20trying%20to%20set%20up%20a%20simple%20way%20to%20cost%20menus%20for%20my%20restaurant.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20will%20have%20all%20my%20products%20and%20prices%20etc%20in%20one%20excel%20sheet%20but%20my%20recipes%20in%20separate%20sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20set%20it%20up%20so%20that%20if%20I%20type%20in%20lets%20say%20apples%20into%20my%20recipe%20sheet%20it%20will%20automatically%20import%20the%20data%20from%20the%20price%20list%20sheet%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-806845%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-806869%22%20slang%3D%22en-US%22%3ERe%3A%20i%20am%20costing%20a%20menu%20but%20i%20want%20my%20excel%20sheet%20to%20get%20data%20from%20a%20seperate%20price%20list%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-806869%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F392968%22%20target%3D%22_blank%22%3E%40simon_knights%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20sounds%20like%20your%20problem%20could%20be%20solved%20with%20either%20the%20VLOOKUP()%20formula%20or%20a%20combination%20of%20INDEX()%20and%20MATCH()%20formulas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20share%20your%20workbook%2C%20I%20could%20look%20into%20this%20further%20for%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
simon_knights
Occasional Visitor

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

 

 

1 Reply

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.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies