Formula help please

  • Thread starter Thread starter Mark Young
  • Start date Start date
M

Mark Young

I am attempting to make a worksheet that would show the
number of carbs in a food item. If beer is picked, then
13.2 carbs should show up. Usually, I would use a
validation drop down list. If I only do one, I normally
do something like this:
=IF(B3=B61,C61,0)
(B3 is drop drop down list area, B61 is the specific food
item, C61 is the number of carbs for that food item)

In order to make it work for every single food item, what
would I have to do? An example of what the list looks
like is:


A B C
Portion Food Item Total Carbs
Alcohol
12 fl oz Beer 13.2
1 fl oz Bourbon-80 Proof 0
1 oz-wt Brandy-86 Proof 0
1 oz-wt Brandy-86 Proof 0
1 oz-wt Gin-80 Proof 0
4 fl oz Medium White Wine 0.9
4 fl oz Red Wine 2
1 oz-wt Rum-80 Proof 0
1 oz-wt Tequila-80 Proof 0

I am a newbie at formulas, so forgive me if I did not
post correctly.

THANK YOU
 
Mark

I have a workbook listing over 850 foods in about 50 different categories.
Gives carbs, protein, fat, calories and fiber content for each. Has a macro
to turn Auto-filter on/off.

As a Diabetic, I find it quite helpful. Yours to try if you respond. I can
send it to your email.

Gord Dibben Excel MVP XL2002
 
That sounds great, but I am looking for a way to build
this formula so I can choose a food and then the carb
count auto fills in the next cell.
 
Mark

Have you investigated VLOOKUP?

Foods in column A, Carbs in column B.

DV drop-down list in C1

=VLOOKUP(C1,A1:B200,2,false) in D1

Hide columns A and B

Gord
 
PERFECT!
Now all you have to do is choose the food and put in how
many servings, the carbs add up. Got it by Breakfast,
Lunch, Dinner, and Snacks. Breakdown by each meal and a
total.

THANK YOU!!!
 
Thanks for the feedback Mark.

Gord

PERFECT!
Now all you have to do is choose the food and put in how
many servings, the carbs add up. Got it by Breakfast,
Lunch, Dinner, and Snacks. Breakdown by each meal and a
total.

THANK YOU!!!
Click to expand...
 
Back
Top