Nested IF Statements Assistance Requested

[RKS2nd]

I am attempting to insert a number in $E3 based on 1 out of 10 text entries entered in $G3. I have created the following nested IF statement.

=IF($G3="Critically High", 10, IF($G3="extremely high", 9, IF($G3="very high", 8, IF($G3="high",7, IF($G3="medium high", 6, IF($G3="medium", 5, IF($G3="medium low", 4, IF($G3="low", 3, IF($G3="very low", 2, IF($G3="extremely low", 1,))))))))))

Unfortunately, even though I am using Excel 2013, I am receiving an error message stating "The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format"

Any assistance is greatly appreciated. If there is a better formula to accomplish the same function, I am willing to try anything.

Roy

 

[RKS2nd]

What exactly is the file extension?

Even though Excel 2013 may allow you to nest more than 7, I would still prefer to use VLOOKUP.
I am no fan of unnecessarily long formulas. They can be a pain to maintain!

No arguments from me. I'm a nubie to writing excel formulas and will be creating a lookup table .