Calorie Counter

[sharp21]

Im creating a a spreadsheet to track daily nutritional information. It is my first one.
On the first sheet I have info on various foods as I come across them. On subsequent sheets I input what I eat daily & it autosums the calories, protein, etc.
What I would like to do, is have it so that I can just type in the food, ie banana, & it will automatically take the values from the first page & input it into subsequent sheets, so that i do not have to re-type or copy paste.
thanks
S.

[MartinShort]

The Syntax is

Please Login or Register  to view this content.

etc.

[MartinShort]

A useful tip for typing in multiple sheets simultaneously is to "<Control> and <Click>" all of the sheets you wish to type on and the type on. Start typing and you'll find that whatever you've typed is now on EVERY sheet. Remember to deselect the multiple sheets when you've finished though.

[swatsp0p]

I don't think Martin addressed the OP's question. It sounds as if they need a VLOOKUP. On Sheet1, make sure your data is laid out in the following format:

Col A is the item (e.g. Banana)
Col B is Calories
Col C is Protien
and so on

This range of data must be sorted Ascending by Column A. Name this range of data "Foods" (or similar)

Now, on Sheet2, set up columns the same order as Sheet1

Use Column A to enter your foods eaten.

Assuming your first entry is in A2, in B2 enter this formula:

=VLOOKUP($A2,Foods,2,0)

In C2 enter this:

=VLOOKUP($A2,Foods,3,0) note that the column reference '2' changed to '3'

repeat this formula in as many columns as you have data in your Foods range, adjusting the reference number to match the column number (B is col 2, C is col 3, etc.)

Then, copy these formulas down through as many rows as you need.

HTH

Bruce

[MartinShort]

Ho hum. Perhaps if I'd read the question a bit more thoroughly. Ce la vie

[sharp21]

ok bruce i think i got it.
ill give it a try & let you know how it works out

[sharp21]

i must be missing something here.
after typing out the instuctions, i then typed "apple" into the food column. the next column, which should have been "calories" read back as #REF!
what gives?

[swatsp0p]

It sounds as if your formula is not looking at the correct range. Please post the exact formula you have in B2 (or whatever cell you are using).

Verify that your range is properly named ("Foods" should cover the entire range of columns and rows that you have populated with your data on Sheet1), and that your list on Sheet1 is sorted Ascending by Column A (the names of the foods).

Let us know...

Bruce