Choose numbers from a list to give a total

[Carty]

Hi. Can you give Excel a target to get to when picking from a list of numbers? e.g. if the list is 1,2,3,4,5,6,7,8,9 and the target set is 22 can you get Excel to pick a selection of numbers to give you 22 - 2,5,7 & 8 for example?

Can this be further manipulated to give you the target with a tolerance?

Thanks

Paul