I have had the same issue for several days now and I cannot for the life of me figure out why I am returning the wrong data.
I'm using VLOOKUP to match the serial #s in one spreadsheet with others in another spreadsheet that have our SAP #s attached to those. However, I am getting a return of SAP #s, but every single SAP # is being attached to the wrong serial #.
For Example:
Serial #: 337261 is being matched with SAP # 232724
But that is incorrect, the correct SAP # for that serial # is 235841
I have cleaned the data, trimmed the data. The data I want is original and not being pulled from a different spreadsheet... This to me seems pretty basic, however it continues to return the wrong information.
Here's the formula:
=VLOOKUP(G2,'Prod Sched'!B:C,2)
I don't think it should matter, but there are over 5,000 rows of data, however, I'm only using VLOOKUP in 2 different columns. Anyone have an idea of what is happening here?
I'm using VLOOKUP to match the serial #s in one spreadsheet with others in another spreadsheet that have our SAP #s attached to those. However, I am getting a return of SAP #s, but every single SAP # is being attached to the wrong serial #.
For Example:
Serial #: 337261 is being matched with SAP # 232724
But that is incorrect, the correct SAP # for that serial # is 235841
I have cleaned the data, trimmed the data. The data I want is original and not being pulled from a different spreadsheet... This to me seems pretty basic, however it continues to return the wrong information.
Here's the formula:
=VLOOKUP(G2,'Prod Sched'!B:C,2)
I don't think it should matter, but there are over 5,000 rows of data, however, I'm only using VLOOKUP in 2 different columns. Anyone have an idea of what is happening here?