If command with lots of conditions

You can try creating a table of values on the side and then using VLOOKUP to get the desired result.

e.g. =Vlookup(A1,$X$1:$Y$100,2,0)

where A1 contains lookup value and table in X1:Y100 contains the matches in column X and return values in column Y

If each player takes on a specified range between, say 0 and 100, then you can try a LOOKUP() like this:

=LOOKUP(A1,{0,10,20,40,60,80,90,100},{"A","B","C","D","E","F","G","H"})

where the first array represents the lower bounds of each range and the second range represents the corresponding results based on the ranges....

Or, on a similar theme.

Create three dynamic named lists in a seperate worksheet "Lookups"

"Team_Members" can be used to validate "Team Member" in the "ConditionTable"

Then in "Sheet 1" Use "ConditionList" to validate say Column A (or your required cell).

Then put a lookup formula in say Column B
e.g.

Please Login or Register  to view this content.

For more on Named Ranges see this link
Contextures - Excel Data Validation -- Introduction
Follow the links as required.

Hope this helps