[SOLVED]Suggest a food based on a persons remaning calorie allowance

[Adam9]

I have what will probably be one of the most simplest tasks for you, but to me it seems near impossible!

I have a table full of foods and their calorifiic value. I need a list of food that fall the total remaining amount of calories they are allowed for that day.

A formula would be the best solution or if someone could point me in the right direction. Would be a great help!

Thanks
-Adam =]

[shg]

Welcome to the forum, Adam.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[Adam9]

Thanks shg! I don't know what to put as the title to be descriptive it will be something vauge but I'll try

[Domski]

Can you not just use autofilter?

Dom

[Adam9]

Thanks for your replies I sorted it used a vlookup to find the amount of calories remaining in the form then had it find an approximate match instead of an exact.