Macro won't record if statement

[TyeReece]

I receive the message that the macro won't or can't record when I try to type in (or paste in) the formula:
=IF(L2="Direct Care","{B0B7824D-9E57-4F71-B86F-CD34BF05ACF5}",IF(L2="Clinical","{96359977-7DE2-444D-8071-6BEE2B1B033A}",IF(L2="Case Management","{BD052071-795C-4295-AAEF-5E9115D72D2B}",IF(L2="Administrative/Program Management","{A915D195-41F9-425D-878B-BAC8D0DB28FE}",""))))

Basically, the text is part of a validation list and the stuff in brackets are unique identifiers for each text. Is there something I'm missing or an easy fix for this?

 

[RoryA]

I suspect the issue is formula length. Have you thought about using a lookup table instead? It would make maintenance easier I think.

 

[TyeReece]

Thanks, I think that will work. I'm rebuilding some things I did about 4 years ago and vlookup is way shorter.