Your VLOOKUP references a named range ReasonsLookup which are currently #REF!s. You might want to look into that. I think it should be A17:B29.