HI
In this thread are two more ways to accomplish this.
Formula Question: How To Convert Phrase to Number.
The switchif and substitute methods do away with the extra table, at the expense of formula complexity. The filter formula adds a table, but is easy and visible to maintain, with a very simple formula that does not need to be changed when new entries are made.
Regards
Rambing Pete