Try the vlookup-function to translate a code to something else (in this case a number). Or write a lot of Visual Basic code. But I think the first is easier.
Kees
I'm intrested in making an employee schedule in excel. My question is, is there a way to get excel to recognise 12-6 or 1-9 as 6 or 8 hour shifts and automatically calculate and total them?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic