Unable to create new calculated column using a lookup value column

Hello All,  I'm not sure if this is a glitch or if I'm doing something wrong. I've done this plenty of times in the past but it is not working now. I have two calculated columns using the LOOKUPVAL...