Simple V Lookup Not Pulling in Values

MegBurns23

Hi All,

I wrote a simple V Lookup and it is not pulling in Values.

Main Tracker Sheet:

First two rows on the Main Tracker Sheet it's pulling values from the Data Dump sheet below. But that third row Material 394611 the VLOOKUP doesn't pull in... Material 394611 has data in the Data Dump (screenshot below)! It keeps on doing this for many rows. A few subsequent rows are pulling values. I made sure all columns are the same Colum type, I valued out the Material #s (in green ) on the original sheet, and both columns on the data dump sheet.

Data Dump Sheet:

What would cause this? The Tracker has 106 rows, the Data Dump is 17K rows. So I am within limits. Any thoughts or help would be much appreciated!?

-Meg

MegBurns23

OK, so I realized they were not numbers. Converted in Excel, re-uploaded, resolved issue!

Thank you!

Paul Newcome

What exactly do you mean by

"I valued out the Material #s"

??

MegBurns23

Saved all material number's as a value (copied and pasted as a value).

Paul Newcome

Do you have any of them that have a leading zero?

MegBurns23

Is this comma a leading zero?

MegBurns23

OK, so I realized they were not numbers. Converted in Excel, re-uploaded, resolved issue!

Thank you!