Excel Help Please?

[Colbaker]

Hi all,

I am trying to create an Excel Spreadsheet to track Calorie intake, I can create a drop box to choose the food i have eaten (from a data set on a seperate page) but i want the next cell to populate with the Calorie info (also on the data from a seperate page)

How could i do this?

Thanks guys

 

[Colbaker]

Thanks for the reply, I have tried what i understood of your Vlookup equation but cannot get it to work, The below is a mockup of what i am going to do on my spreadsheet, as you can see i have the DATA on the right (this will only be used to populate the data on the left), I have drop down boxes on the left under the Food column and next to it i have a column for Calories, What would be the exact Equation to enter the numeric value next to the food type in the data section when selecting it relevent food type in the drop down box?



Many thanks

 

[Colbaker]

Formula in d4

=vlookup(c4,$f$4:$g$10,2,false)

Should work (the $ signs mean you can C&P down the column

Thanks muchly that works nicely, also helps me to understand it a bit more, only issue i have is that the cells which has the equation in but there is no data entered in the drop down box has #N/A in it, is there a way to make it blank?

The reason i ask is that i have added a sum at the bottom adding al of the number populated in the new cells but becuase of the #N/A in some cells the sum also has #N/A