It is because the value you are looking up doesn't equal the value in column A. You are trying to match "Keith E" in column A, but all of the cells that have "Keith E" in them are actually "Keith E " ... they have an extra space after the E. Change cells A207:A248 to "Keith E" (without quotes) and it should work fine.

- Moo