Find numbers in a column that equal a number in a cell.

I have a column of 1500 numbers. I want find a combination of numbers in that column that equal a number in a specific cell. There may be two numbers in the column that equal that number if added up or more numbers. How can I do this.

Thanks

Should be able to accomplish this using the "=SEARCH" function.

http://office.microsoft.com/en-us/ex...in=HP010342656

Thanks for the input and some great tools that I will use later but I am looking for something different. Example:

Column A
1
2
3
4
5
6
7
8
9
10

and b1 has 20. Is there a VB that will identify all formulas possible out of column A to total B1 (20)