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

Copper Contributor

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.