Vlookup + sumif with multiple arguments in a single cell

[gfunkb73]

Hey guys.

I need a formula to lookup the sales orders then add the amounts so it equals 118.00 in the "TBD" cell.

Sales orders	Total amount		Sales orders	Amount
123456789 / 234567890	TBD		123456789	56.00
			234567890	62.00
			Total	118.00

<tbody>
</tbody>

I could "Convert text to number" but my Excel file has 1 thousand lines, and sometimes there are 50 numbers in a single cell.

Thanks guys

 

[gfunkb73]

Nobody?