Sounds like a typical "subset sum problem". In Excel, I usually expect an approach like this one: http://www.k2e.com/tech-update/tips/...specific-value