Help with an algorithm to do the following:



Hello all,

I am trying to implement the following, but I need help/suggestions for an
algorithm that will help achieve it:

I have 1 item that has 3 categories (numerical values). I need to find the
right combination to get a matching desired total for all 3. For example:

Item1 | 60 | 40 | 10
Item2 | 100 | 0 | 7
Item3 | 10 | 50 | 13
Item4 | 0 | 10 | 4

If I am looking for: 420 | 100 | 54 then I would get the following matching:

4 Item2
2 Item3

What would be the best approach?

Thanks!
Fadi



.



Relevant Pages