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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sales orders[/TD]
[TD]Total amount[/TD]
[TD] [/TD]
[TD]Sales orders[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]123456789 / 234567890[/TD]
[TD]TBD[/TD]
[TD][/TD]
[TD]123456789[/TD]
[TD]56.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]234567890[/TD]
[TD]62.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Total[/TD]
[TD]118.00[/TD]
[/TR]
</tbody>[/TABLE]

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?