Forum Discussion
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 ...
It is most likely a format issue.
The lookup value is not the same format as the lookup column. One of them is text and the other a number.
Check with ISTEXT() or ISNUMBER().