I work for a wholesale distributor, we use excel to upload price lists into our system, we use SAP.

Most times I have no problems with vlookup, I take sheet 1 to work with, it has the suppliers part numbers in column 1 and my cost in column 2, I then copy on sheet 2 my part number with the vendors part number, I will then on sheet one do a vlookup and 90% of the time it works.

When it does not, I try a copy past values, I try a clean and no matter what it does not work, I format general, text everything and it still don’t work, then one day I double clicked the number on sheet 1 column one and the numbers move from the left to the right and wam, vlookup puts in my part number, if I double click all of them they work, the only time it has no problems is when there are letters at the end.

Can anyone help me?

roger