Formula to check combinations in one column to see if they equal any combinations in another column

[kong1802]

We have over 100 accounts that need daily reconciliation. This task is very time consuming. I've used index and match, however, most of our reconciliations involve using combinations of values to match to a value or another combination of values in another column. Is there a formula that can check column B combinations against values or combinations in column A and produce a match in column C? For example:[TABLE="width: 500"]
<tbody>[TR]
[TD]1285.70[/TD]
[TD]1200[/TD]
[/TR]
[TR]
[TD]2928.16[/TD]
[TD]85.70[/TD]
[/TR]
[TR]
[TD]11427.02[/TD]
[TD]2600[/TD]
[/TR]
[TR]
[TD]38.76[/TD]
[TD]4000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]