## [Solved] Food recipe calculator

### [Solved] Food recipe calculator

Hi everyone,

I'm trying to create my food recipe cost calculator and I'd like to create a calculator page (easy enough) and a pantry page (2 columns Ingredient and cost per unit).
I'd like to choose from a dropdown in the calculator the ingredient from the pantry and have a cell beside give me the price per unit from the pantry, that way it is easy for me to create the formulas without every time modify the calculator page.

I hope it is an easy task for calc veterans.

tank you.
Giuseppe
Last edited by Hagar Delest on Fri Nov 08, 2019 9:17 am, edited 1 time in total.
Reason: tagged solved
Open office 4.1.7
Windows 10
Giuseppe.btc

Posts: 3
Joined: Wed Nov 06, 2019 7:37 am

### Re: Food recipe calculator

I'd like to choose from a dropdown in the calculator the ingredient from the pantry and have a cell beside give me the price per unit from the pantry,

Try the function VLOOKUP(). That is the English name of the function, I do not know what locale settings are you using.

Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.0; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.

Zizi64
Volunteer

Posts: 8771
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

### Re: Food recipe calculator

I upload the example, as you can see I'd like to have a drop list for the ingredient and have the price change following the pantry sheet prices
Attachments
foodcalculator.ods
Open office 4.1.7
Windows 10
Giuseppe.btc

Posts: 3
Joined: Wed Nov 06, 2019 7:37 am

### Re: Food recipe calculator

The formula, using US English, for the entry on row 3 would look like
Code: Select all   Expand viewCollapse view
`=VLOOKUP(A3;Pantry.A\$2:B3;2;0)`
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.

RusselB
Moderator

Posts: 5853
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

### Re: Food recipe calculator

Thank you very much
Open office 4.1.7
Windows 10
Giuseppe.btc

Posts: 3
Joined: Wed Nov 06, 2019 7:37 am