Calorie Counter

[Chris Bailey]

Hi......Im kind of new to excel but very good with computers. I want to make
a calorie counter that has the particular foods i eat already in a database
ready to be copied over to another page.

Just a quick example....if i enter salmon it will lookup data from the table
and automaically copy the data from the database an place it on a days food
table ready to be calculated...

I need a few guides or some idea of where to start if anyone has any
ideas!!!!!!!!!


Thanks


__________ Information from ESET Smart Security, version of virus signature database 4676 (20091210) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Gord Dibben]

VLOOKUP table is the usual way to go.

See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xlFunctions02.html

You may also want to investigate the possiblitiy of using a Data Validation
dropdown list for choosing your foods.

See Debra's site.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP

 

[Chris Bailey]

Thanks for the links......exactly what i was looking for....should be a
little easier now

Thanks again

VLOOKUP table is the usual way to go.

See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xlFunctions02.html

You may also want to investigate the possiblitiy of using a Data
Validation
dropdown list for choosing your foods.

See Debra's site.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP




__________ Information from ESET Smart Security, version of virus
signature database 4676 (20091210) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4676 (20091210) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Gord Dibben]

You're welcome.

Good luck


Gord

Thanks for the links......exactly what i was looking for....should be a
little easier now

Thanks again





__________ Information from ESET Smart Security, version of virus signature database 4676 (20091210) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Bernd P]

Hello Chris,

I suggest to look at www.wolframalpha.com:

Enter, for example:
one slice of bread and 100g salmon

And you will get more information than you can probably arrange for
with Excel.

Regards,
Bernd

 

[Chris Bailey]

Thanks for that link Bernd P ....... Will come in really useful when
calculating my meals...

Thanks again

Chris

Hello Chris,

I suggest to look at www.wolframalpha.com:

Enter, for example:
one slice of bread and 100g salmon

And you will get more information than you can probably arrange for
with Excel.

Regards,
Bernd

__________ Information from ESET Smart Security, version of virus
signature database 4686 (20091214) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4686 (20091214) __________

The message was checked by ESET Smart Security.

http://www.eset.com