Help with expanding this formula pls :)

  • 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.
 
Mark

See one possible solution in Excel.misc

Best to stick with one group and one thread. All the regulars scan all the
Excel groups so one post is enough.

Gord Dibben Excel MVP XL2002
 
Have you tried using the Vlookup or index formula. Happy
to help you more if required.

Cheers
 
Back
Top