Hi John:
Your formula is OK! The problem is with the way the Lookup value is entered. If you enter the lookup value literally in the formula, text values must be enclosed in quotes. The prefered way is to use Lookup value in the formula by cell reference.