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
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies