Excel function/what-if analysis
 

Is there anyway using Excel either to use a function or create a formula for
it to
lookup a list of numbers i.e. 12, 13, 23, 18, 4, 6, 76, 87. when added
together would add up to a value located in another cell i.e. 25.

Could it return the numbers from the list which is used to get the value in
the other cell?

Would using any of the What-If analysis tool be applicable - if so which and
how would be best.

Thanks in advance.

Assuming you want to have 2 numbers that match, you could use a formula like
this. Let's say the number you have is 12 and it's in A1. The series you
are checking is in B1:B8
..
=VLOOKUP(25-A1,B1:B8,1,FALSE)

If you don't have a match, you'll get N/A. There are ways around this,
but let us know if that's what you want.


"Su" wrote in message
...
Is there anyway using Excel either to use a function or create a formula
for
it to
lookup a list of numbers i.e. 12, 13, 23, 18, 4, 6, 76, 87. when added
together would add up to a value located in another cell i.e. 25.

Could it return the numbers from the list which is used to get the value
in
the other cell?

Would using any of the What-If analysis tool be applicable - if so which
and
how would be best.

Thanks in advance.

Thank you for your response.

If i was to use this for the whole list I could indicate the numbers
individually for it to cycle through to match it up.

But what if i was to have more than one combination?

Cheers

"Barb Reinhardt" wrote:

Assuming you want to have 2 numbers that match, you could use a formula like
this. Let's say the number you have is 12 and it's in A1. The series you
are checking is in B1:B8
..
=VLOOKUP(25-A1,B1:B8,1,FALSE)

If you don't have a match, you'll get N/A. There are ways around this,
but let us know if that's what you want.


"Su" wrote in message
...
Is there anyway using Excel either to use a function or create a formula
for
it to
lookup a list of numbers i.e. 12, 13, 23, 18, 4, 6, 76, 87. when added
together would add up to a value located in another cell i.e. 25.

Could it return the numbers from the list which is used to get the value
in
the other cell?

Would using any of the What-If analysis tool be applicable - if so which
and
how would be best.

Thanks in advance.