excel query

[Reasteh]

Hi

In excel for example i have a column of numbers 1 - 10

i want to be able to type a value into a cell and it would pick from this column the numbers required to give this figure

e.g i need the number 13, it would then pick a random combination i would need to get this such as 10 + 3 or 5 + 8 etc and show which ones its selected


would something like this need to be done in vb?

 

[Reasteh]

this would just be as an example, if i could do this i could use it for a manufacturing process where a measurement is given and excel would tell the operator which combination of blocks he could use on a machine to get this measurement