You need to code your values always the same:

<Tier> <Division> <number of LPs> 

for example: Gold I 10 LP

Then you need translate function:

First split your input into those 3 categories:

First space:

=FIND(" ", A1) //returns "5"

First word:

=MID(A1,1,FIND(" ", A1)-1) //returns: "Gold"

Second space:

=FIND(" ", A1,FIND(" ", A1)+1) //returns "7"

Second word:

=MID(A1,FIND(" ", A1)+1,FIND(" ", A1,FIND(" ", A1)+1)-FIND(" ", A1)-1) //returns "I"

Third space:

=FIND(" ", A1,FIND(" ", A1,FIND(" ", A1)+1)+1) //returns "10"

Third word:

=MID(A1,FIND(" ", A1,FIND(" ", A1,FIND(" ", A1)+1))+1,FIND(" ", A1,FIND(" ", A1,FIND(" ", A1)+1)+1)-FIND(" ", A1,FIND(" ", A1)+1)-1)

Now build a table with "tier and division code values" like this:

So each Tier and Division will be translated to an integer value.

Now use the build table to use each FIND results in a VLOOKUP function:

=<value of first word> + <value of second word> + <LP>
=VLOOKUP(<1st word you've found>,<range with your Value tables>,2,FALSE)+VLOOKUP(<2nd word you've found>,<range with your Value tables>,2,FALSE) + <3rd word you've found>

So in my example http://imgur.com/SSea2md it looks like this:

=VLOOKUP(MID(A3,1,FIND(" ", A3)-1),$A$9:$B$18,2,FALSE)+VLOOKUP(MID(A3,FIND(" ", A3)+1,FIND(" ", A3,FIND(" ", A3)+1)-FIND(" ", A3)-1),$A$9:$B$18,2,FALSE)+MID(A3,FIND(" ", A3,FIND(" ", A3,FIND(" ", A3)+1))+1,FIND(" ", A3,FIND(" ", A3,FIND(" ", A3)+1)+1)-FIND(" ", A3,FIND(" ", A3)+1)-1)