Extract numbers to make an exact result

  • Thread starter Thread starter Marian
  • Start date Start date
M

Marian

I have this problem: I have group of numbers and one exact
number called Result. How to find the combination of these
group of numbers to obtain number which is equal to the
result?

Group of numbers:
10
25
34
40

Nubmer called "Result":
59

It should returns numbers 25 and 34. Any idea?

Thanx

Marian
 
Marian

In A2 I put the result 59
In B4:B8 I put the group of Figures 10, 25, 34, and 40
In C4 the Formula =$A$2-B4
In D4 the formula =VLOOKUP(C4,$B$4:$B$8,TRUE)
In E4 the formula =IF(C4=D4,B4,"")
In F4 the Formula =IF(E4="","",$A$2-E4)
Copy all the formulas down to row 7

The results should be the pairs in columns E & F

Alan
 
Back
Top