Thank you for looking at my question,
I have a workbook in which I am trying to run VLOOKUP() function. The search string on sheet 1 and the target on sheet 2 are of the same length (no leading/trailing spaces) and the cells in each sheet are formatted as General.
The search string is present in the target data.
There is a difference between the two datasets in the way the all-numeric cells are displayed; on sheet 1 cells containing all-numeric strings display their contents as if it were a number (right-justified) but on sheet 2 the same string is displayed as a string (left-justified) and with a comment about the number being stored as text but this is the only difference.
How do I overcome this issue please?
I have attached the file in question.