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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup returning wrong results 0
Excel Need Countifs Formula Help 0
Find numbers in a range that sum up to a specified number 6
Remove an extra space after a number. 3
Need help with formula to average numbers while ignoring "0" value 1
OR in SUMPRODUCT formula 3
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
SMALL function to find X smallest number greater than Y 6

Back
Top