Quick Nutrition Guide

I am trying to set an existing spread sheet to fill in FAT CARB & PROTEIN Values after I type in the food name. I have 1 worksheet with the A column with the food name, B is fat, C is Carb and D is Protein. I have tried to use VLookup, but I know I am doing something wrong because the only answer I get is REF.

How my actual document is set up:

Worksheet 1
"Food Chart"
Column A = name of food
Column B= Grams of fat
Column C= Grams of Carb
Column D= Grams of Protein

Worksheet 2
"Week 1"
A2 is blank where I would input the name of the food
B3 is blank where I would input the fat
B4 is blank where I would input the Carb
B5 is blank where I would input the Protein

My goal is to put the food in A2, and have B3,B4, & B5 fill in automatically from the information on the "Food Chart" page. This pattern repeats itself for 5 foods in column A and 5 meals across per day. Then it repeats itself for 7 days a week, and that is per work sheet. I have 9 weeks set up this way.

I am sure my explanation is as confused as I am right now, but any help is appreciated.

Thank you, it worked, and I will be able to sleep at night...

I do have one more question. How do I get the value in the B3,B4,B5 to equal 0 if I have not entered a food in A2? It is screwing up other formulae that I have set up. Right now, I entered "blank" into my food list, and put the numbers at 0,0,0 which has solved the problem, but I am sure there is a better way. Thank you very much for your help.