Find Numbers in a range that to a specific number

G

GregR

Is there a way to find 2 numbers in a list that would add up to a specific
number. Needed for bank reconciliation. The numbers can be anywhere from 5
to 500
in the list, there are some negative numbers and I only want one
combination. TIA

Greg
 
J

Jason Morin

Assuming your list of numbers are in A1:A50 and the total
number is in F1, try this in B1 and copy down to B50:

=ADDRESS(SUMPRODUCT(--(A1+$A$1:$A$50=$F$1),ROW(INDIRECT
("1:50"))),1,4)

If there are any feasible combinations, a cell reference
will appear next to a number. That number, but the number
in the cell reference, will equal the number in F1.

HTH
Jason
Atlanta, GA
 
Top