Results 1 to 4 of 4

Quick Nutrition Guide

Threaded View

  1. #1
    Registered User
    Join Date
    01-24-2005
    Posts
    2

    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.
    Last edited by shema; 01-24-2005 at 02:20 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1