OK heres is what I am trying to accomplish. I have a worksheet (Nutrition Data) which contain a bunch of nutrional data (protein, carbs, fat, etc) on various food products (with unique names).

What I would like is to create a new sheet (in the same workbook) that would allow me to lookup/enter the unique description of a food product (that is found in the "Nutritional Data" Sheet) then have the remaining data be automatically filled out in the adjacent column. So the end result is a multitude of rows which I can enter in my food products, the nutritional data would be autmatically pulled from the "Nutrional Data" sheet, and then the data can be totaled. I have been struggling with the VLOOKUP function with no success, perhaps there is a cleaner for effecient way. Maybe functions is not the way to go, maybe I need to go with the Excel VB.

Any sample sheets that perform similarly to this, examples, tips, suggestions, etc?