Which entries add up to x?

I am trying to find a way to do the following:

I have a list of x numbers (lets say 100 numbers)
I know that 2 of the numbers in the list add up to y (lets say 255.21)

Is there a way in Excel to find which two specific values add up to that value? (In the hypothetical above, it may find 2 values that are 130 and 125.21)

Finally (and only if the above can be accomplished), how would the procedure change if you had to combine 3, 4, or z numbers to reach the specific value?

Many thanks for any tips you can offer!!

This is GREAT, except it doesn't seem to work with negative numbers... any idea how to change that?

For example, the following does not work:

10
11
12
-1
13
14

if you're looking for 9, it won't come up with any. if you're looking for 10, it would only come up with 1 combo, when there are 2.

Any help will be greatly appreciated!

Originally Posted by koticphreak

This is GREAT, except it doesn't seem to work with negative numbers... any idea how to change that?

For example, the following does not work:

10
11
12
-1
13
14

if you're looking for 9, it won't come up with any. if you're looking for 10, it would only come up with 1 combo, when there are 2.

Any help will be greatly appreciated!

Google for SOLVER

any easy way to mod it to also include negative numbers?