Help creating log with data from table

I am guessing the that simply fact that my "data" was not alphbetized was the reason for my strange errors.

Thank you so much. That worked great, BUT, I would like to make better. The VLOOKUP is perfect for the nutrional data, but is there a way to have cell A1 on Sheet2, be a "selection list" or "drop-down" list of Column A in Sheet 1? That way the user will know exactly what options he has to pick from, rather than stabbing in the dark, hoping to hit one similar, or searching Sheet1 just to find a "food product"? I suspect this would require the VB Scipting. I have tinkered with one script that might do this, I'll have to experiment.

swat, i see and understand exactly what you are talking about. That will accomplish exactly what I am after. Thank you gentlemen. Now lets see if I can make it happen.

Drats! Excel 2002 will not allow me to reference data on another sheet for "validation criteria". Has anyone with a new version successfully referenced another worksheet with this feature.