Finding TWO numbers from a range of numbers to match a target value

**Eero** · 10-18-2014, 09:09 AM

I'm very new with macros and have been looking for a solution for couple of days now but I have only found very complicated ways to find ALL the possible combinations to reach the target.

Instead I have a column of numbers, any two of which won't sum to same as another pair. I would need to write a macro that would find the pair of numbers that will sum to a target value?

Any help would be appreciated.

**briguin** · 10-18-2014, 09:50 AM

Based on the question... I'd write a macro.
or
try a funtion in a cell.
=If(Cell1+Cell2 = TargetValue,1,0)
or
=if(sum(Cell1,Cell2) = TargetValue,1,0)

An example might help.

**GCW esq** · 10-18-2014, 10:08 AM

Not sure what you're after, but this might work:

=IFERROR(INDEX($D$1:$D$7,MATCH($E$1-D1,$D$1:$D$7,0)),"")

I listed numbers in cells D1 to D7, and the target value in E1.
The formula, which I put in cells F1 to F7 (changing D1, D2...), calculates the value of the target minus the values in each cell in the list (E1-D1, E1-D2, etc), then uses INDEX and MATCH to look for the result in the list.
I also put an IFERROR check in there, to avoid errors showing when the result was not found.
Successful values show in cells in column F, beside the number in column D which it adds to to get the target number.