Need Help on how to approach a possible if then loop

Hello all,

Im having trouble creating a Pen&Paper Roleplaying Character sheet. I know it isnt a professional document, but my long-distance friends and I began a Gurps campaign remotely and an excel character sheet would help immensely.

The peoblem that I am having is organizing skills. In Gurps, there are mental skills based off IQ (these are categorized by an "M"), and physical skills based off of dexterity (represented by "P"). Under these two catagories are several levels of difficulty; Easy ("E"), Average ("A"), Hard("H"), and Very Hard ("VH"). Skills are then categorized with "MA" or "PH", such as "Singing PE".

The player use a point system to increase proficiency with their skills. Some of the difficulty levels raise by twos after a half point and then a point are spent into them (1/2, 1, 2, 4, 6, 8) but then others raise by a factor of 2. If the player puts a point into a Physical Hard skill, then they would get that skill at their Dexterity -2, 2 points in would get them Dexterity -1 and so forth.

What Im trying to do is have drop down boxes for the skill difficulty and how many points are spent into it. Then use those two factors to add to the dexterity or IQ stat and then post the result in a field.

Any help would be appreciated.

I would like I2 to be a drop list to show all available skills. V2 to V8 is a small list of of a much larger number of skills.

I want to make it where once a skill is selected from the drop-down list, the difficulty is auto-filled (PE, MA, etc.). Then when the difficulty is auto-filled the appropriate point cost row (Y2 to Y8) is enabled as another drop-down list in column M, "Pt. Cost".

The end user will then select the amount of points to put into the skill (by way of the "Pt. Cost" drop-down list) which will then use the appropriate modifier found from the tables in the P column and applies it to the appropriate stat from C and automatically fills in the "Level" column N. Please let me know if more clarification is needed.

The "Skill Name"and "Difficulty" work perfectly. For "Pt. Cost", Im wanting the drop-down list that shows up to allow the possible point values that are listed horizontally to the right of the difficulty values, starting in column X. If you look at the two tables in column "P" you'll see that if you put 1/2 a point in a PE (Physical Easy) skill, you get a modifier of -1 to your DX score. The DX score in this example, I have set to 12. So, with a 1/2 point spent into "Jumping" (PE) you would get a "Level" (Column N) of 11. If you select 1 point from drop-down box in column M then it would become DX with no modifier, being 12. If you note the pattern for the different mental and physical difficulties, you see a few variations. Im not sure how to set the list though.