DB reference, help please

[smittycft99]

Below is my original post.
The VLookup is great, but my DB is very large and user's will have to type in the Exact phrase into A1 to get B1,C1,D1 filled in. But for A1 the phrase could be long, ie "Rice Crispies treats". Is there a way for the user to type in Rice and then go to a small drop menu showing all entries in db with "rice", I know you can do data validation (and that the DB has to be in the same worksheet) but then the drop menu would be very long. Any ideas, thanks a million in advance

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

[Juan Pablo González]

You could try with ommitting the last parameter of the VLOOKUP to find the closest match (Or set it to TRUE)