I have a football predictions spreadsheet that I would like help with
working out a formula.

An example of the spreadsheet is here
http://www.geocities.com/gloriousgle...ctionstest.xls

A persons score predictions are put into the cells B1(thru to B13) and
D1(thru to D13). What I would like to do is when I put the 'Result'
scoreline into G4(thru to G13) and I4(thru to I13) I would like the
relevent amount of points to be shown in J4(thru to J13).
0 points for a wrong prediction
1 point for correct result
3 points for correct result and scoreline.

Many thanks for any help with this.
Glenn