Points Ranking Formulas

[Max]

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(E7,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.

 

[Guest]

Thanks Max,

I think I'm starting to get it now. It takes awhile to understand how the
formulas work.

You did a great job on this!

Cabo Wabo Jim

 

[Max]

You're welcome, Jim !