World Cup 2014 - Bet checker formula (1X2)

[quakerzoom]

Hi guys!

I have two columns with values. The first column contains personal bets in a standard 1x2 system for betting. The second column contains results of the games. The third column contains points awarded for correct betting.

Betting Game Result Points awarded
1x 1 2
X 2 0
1x2 x 1
2 1 0
1 1 3
X 2 0
12 2 2[TABLE="width: 500"]
<tbody>[TR]
[TD]1x[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]2[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1x2[/TD]
[TD]x[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]2[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]


What i want to do is to check column 1 against column 2, and award points in column 3.

If there's a valuematch in column 1 when it only contains one value (1, x or 2), it should give 3 points in column 3, otherwise 0.
If there's a valuematch in column 1 when it contains two values (1x, x2 or 12) if should give 2 points in column 3, otherwise 0.
If there's a value called 1X2 in column 1, it should give 1 point in column 3.

I have 40 result sheets to correct with 48 games in each. So in total 1920 checks.