Vlookup not working properly

[Sphinx404]

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?

 

[L. Howard]

Trythis with the fourth argument, exact match.

=VLOOKUP(G2,'Prod Sched'!B:C,2,0)

Also, your serial number will need to be unique, no dupes, or it will return the first match only.

Howard

 

[gaz_chops]

Try

=VLOOKUP(G2,'Prod Sched'!B:C,2,0)

 

[Sphinx404]

You know.... When using the formula function that excel provides, it would be nice that they put in the "0" for you, it didn't even cross my mind. I should stick to typing out my own functions instead of letting excel input the formula for you.

Worked flawlessly guys. Thanks for your help.

 

[gaz_chops]

You're welcome.

 

[ykhxbkdj]

the data should sorted in ascending order

 

[gaz_chops]

the data should sorted in ascending order

Not for an Exact match.