View Single Post
  #1   Report Post  
Su
 
Posts: n/a
Default 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.