Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

vlookup not working unless I press delete after search criterion

I have 2 sheets that I am using vlookup to find and fill in data from one to the other. I am using a 6 digit number for the search criterion which is listed once in both sheets. I get #N/A unless I go to the cell referenced for the search criterion in the first sheet and press delete after the number. It doesn't seem to have anything there and I can't space over but this fixes the problem. Can anyone help with a better solution than what I am currently doing?