Match a combination of numbers in a range with a Specific Number

Is it possible to create a formula to Match a combination of numbers in a range to Equal to a Specific number?

Ex: Specific number = 1,563
Have a range of cells, maybe 100 cells, with an amount in each cell.
Is it possible to find a combination of 1 cell to ? cells that would equal the number 1,563?

Thanks

i found this the other day
from ozgrid
here
http://www.ozgrid.com/forum/showthread.php?t=58000
and wanted to test it but havent as yet coz i dont have the solver add in but you might

Thanks to Mike for asking a really interesting question and equal thanks to martin for keeping track of other site posts, updating self and sharing with others.

solver coupled with scenario management & pivot table can help in many day-2-day practical situations like budgeting and forecasting. i appeal to everyone that someone should try to explain with the help of an example.

This code is (slightly) adapted from Tushar Mehta's original:

Please Login or Register  to view this content.

Thanks for the Solutions. I will give them a try. This is my first time at asking a question in an Excel forum. You all are a great help. I think I will continue to hang around. thanks again. Michael

Martin's answer using Solver from ozgrid WORKED!!! Thanks
I will try the other solutions later.

Michael