Easier to start all over, Jim <g. Now that I see your detailed set-up,
here's the formulas you need to compute the points. I've implemented these
in your file and will send it back to you.

Placed in F7:
=IF(OR(E7="",E$4=""),"",INDEX(Sheet2!$B:$B,MATCH(E 7,Sheet2!$A:$A,0))
+E$4*5*INDEX(Sheet2!$C:$C,MATCH(E7,Sheet2!$A:$A,0) ))

Copied F7, then with CTRL key held down,
selected cells H7,J7,L7,N7,P7,R7,T7,V7,X7
Then right-click paste special formulas OK

This pastes the same formula adjusted relatively where required into all the
required cells. Then just copy the formulae down the respective columns.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--