Return Items from a list that its sum is equals to a given value

Help Something Else
1

I have a robot that needs to input orders in ERP

The product the robot recives is the full package, but to input in the system it has to put every single item that completes the package. For the example below i’ve used a car.

image

Full Pakcage: Car, unit price 763,39

I know that the itens that complete this package are: Wheel 1, Color 2 and Tire 3 because of the sum of the unit price.

  • It’s not mandatory the package to have 3 itens, this is just an example!

Is there any way to the robot return this 3 single itens?

2

can you show the result excel you want? @guilherme.dias

3

In this case:

image