Simple V Lookup Not Pulling in Values
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!?
Help Article Resources
Check out the Formula Handbook template!