Formatting Help

**Tazni** · 01-20-2012, 08:21 PM

I have a very specific requirement for my excel document, however I cannot for the life of me remember how to achieve this function and it is quite specific.

I have a database of foods with Calorie, Carbohydrate, Protein & Fat values beside.
On the same page, I then have a food diary in which I want to be able to enter what I have eaten, and the values that coinside with that food from the database appear and add up in a seperate column which helps me add up and tally my total Calorie, Carb, protein & fat intake for the day. Can anyone please assist me with this function please, as I am running out of patience and time

Any help is greatly appreciated!

**TMShucks** · 01-20-2012, 08:28 PM

Suspect you're looking for VLOOKUP. Or, possibly, just LOOKUP. Or you may have used INDEX/MATCH depending on the layout of your sheet.

Regards, TMS

**ExcelIsEasy** · 01-21-2012, 04:21 AM

Here you have tutorials:

VLOOKUP, HLOOKUP, INDEX function

**Palmetto** · 01-21-2012, 08:29 AM

Sounds like you could use a Pivot Table, if the data are correctly structured.

**dilipandey** · 01-21-2012, 08:41 AM

Hi Tazni,

Welcome to the forum.
As you see that our helpful forum members are coming up with solution(s), would request you to upload a sample file to enable them to give a quick try.

Regards,
DILIPandey

<click on below 'star' if this helps>