I understand the matching value formula in excel, but I'm looking for
something a little more complicated. I'm trying to take a value in column B,
and see if any combination of items in A equal that value, and if it does
what items are used to equal the amount in column B. I'm looking for
whatever help I can get. An example is below, and thanks for you help.

Column A Column B
1 4
2 7
5
47
544

For 4, the there would be no possiblity, as none of the numbers added
together can equal 4. The answer for 7 would be 5+2.