Easy one, referencing DB,please help

[smittycft99]

Thanks in advance for your help.

I have a DB:

Food Item Carbs Prot Fats
cereal 45 15 3
milk 20 20 1
bread 45 13 2

Then on another worksheet
when someone types in "cereal" in A1,
Then B1 gets "45", C1 gets "15", D1 gets "3"

Database is in worksheet: database
Menu is in worksheet: Nutrition Log

Thank you again

[Corticus]

column A is food
column B is Carbs
column C is Prot
column D is Fat
(for example)
row 1 is first entry
on sheet 2 in A1 put nothing
in B1 use:
vlookup(A1,Sheet1!A1:D4,2,False)
in C1 use:
vlookup(A1,Sheet1!A1:D4,3,False)
etc...

[Brian from Maui]

In B1 =VLOOKUP(A1,range,2)
In C1 =VLOOKUP(A1,range,3)
In D1 =VLOOKUP(A1,range,4)

Column with cereal etc.. sorted

[smittycft99]

thanks guys!

[smittycft99]

thanks guys!