creating a complex scoring system on excel

Im fairly well equipped for most of Excel, or so i believe...but in my latest project i dont know where to begin and wondered if anyone had any suggestions:

Problem/Project:
create a unique scoring system on a set of given criteria that enables an even split in work for team members. so i.e. work comes in, and depending on the criteria of work its then passed to the relevant team member based on points. At the moment work is allocated A-Z which is working out unfair on team members as some are getting more/less work than others...a points system will enable a even split. so if a piece of work scores 30 points it goes to a junior member, if a piece of work scores 80 points it goes to a senior member and so on...my problem is how to link the points and criteria...Im guessing joint vlookups will be needed.

the only other way i can think a system is similar is like a fantasy football system...points based on criteria.

any suggestions would be great
like i say this is a complex task for me!

You mean like this? (See attachment)

wow thats great. thank you so much.
the only problem i have now is that i have 2,000 records to ''tick or cross'' of against the criteria...there must be a quick way of doing this like a vlookup in to the data i already have? :/
thank you again my friend

Of course, but what does the data you already have look like!?