Create a drop down list and use Lookup to get corresponding items

I am making a spreadsheet for food and calories, On sheet one i have a meal tracker, I want to have a drop down list in colum 1 that references the food list on sheet 2, column A=food, column B=Protien, column C=Carbs, column D=fat. The values from Sheet 2 columns B-D would then be inserted into Sheet A in the respective slots. I have fiddled with vlookup and tried numerous things but I can't seem to figure this out. Any help would be appreciated!

First, name the Food Range (single column range) in Sheet2 through Insert|Name|Define... call it Food...

Then in Sheet 1, where you want the dropdown, go to Data|Validation and select List... enter =Food

then, assuming this is in A2,

Then in B2, =Vlookup($A2,Sheet2!$A$1:$D$100,Columns($A$1:B$1),0)

where Sheet2 A1:D100 contains your food table...

copied across to get next values in matching row.

Try using this formula instead:

=IF(Isnumber(Match($A2,Sheet2!$A$1:$A$100,0)),Vlookup($A2,Sheet2!$A$1:$D$100,Columns($A$1:B$1),0),"")

adjusting ranges and references to suit. (this will return a null if match not found)