Formula for finding matching sums?

[Snoch]

I didn't know how to explain this in the title, so I will try to explain it here.

I have three columns of data. Identification #, Sales Amount, and Posting Amount.


An Example:

Ident #-----Sales Amount---------------Posting Amount
1-------------------$1-----------------------------$10
2-------------------$7
3-------------------$9


I want to know if there is a formula that will take an amount (for this example, $10), search through another list (sales amount) for amounts that add up to the searched value ($1+$9=$10), and finishes by display the corresponding values in another column. (In this case, I'd want it to display 1 and 3).

I don't know if this seems possible, if it would be a combination of formulas or what, but any help would be appreciated.

Also if anybody thinks its not possible, please say so.

[daddylonglegs]

Hello Snoch,

I assume your example is a simplified version of what you need. If so this isn't a trivial problem and you probably need VBA, look here for a potential solution