That's odd... I tested it in Excel 2003 & Excel 2002 and it works perfectly.
Obviously, "CC" was one of the values in the first column of my lookup range.

Maybe you are missing  a required reference to a library (I don't know which
one it would be). I will keep trying to figure out why you are having this
problem.