I'm using vlookup to find a value that I can see exists in another book, but Excel keeps returning an #N/A. One of the values is in General form, while the other is Number form, which I know is the root of the problem. However, the value is a number that is 11 characters long so when I attempt to change the formats to match, I end up with a scientific number, which is not helpful because the first 9 digits are the same in the lookup field. How could I fix it?
Solved by V. L. in 23 mins