VLOOKUP breaks after copy-paste

I have a VLOOKUP formula that simply takes a code and outputs the full text description attached to that code, stored in another sheet.

If you type the code, it works great, no problem.

But if you copy-paste the code, nothing happens. Why ?

Calculation is put as Automatic, and Calculate now doesn't do anything (???).

I have tried Ctrl+Alt+Shift+F9, and I can see the formulas updating without anything changing.

I have tried switching between 'General' and 'Text' as the type of the column, same story.

But simply double-clicking inside of the cell updates the formula without a hitch.

Also, please put some effort into this forum, trying to post 4 messages in 900 seconds isn't spam, especially when your UI is so bad that you have to look to the tiny text on the right side to notice a Label is required.

Edit : Btw a spam filter is useless if you let the same account bypass it through a VPN.