stephen,

If you are trying to do this just in the workbook, you could always create a list and then do a vlookup to get the value, this would save you a lot of time. You would not even have to write a single if statement.