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.
