Simple V Lookup Not Pulling in Values
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
Best Answer
-
OK, so I realized they were not numbers. Converted in Excel, re-uploaded, resolved issue!
Thank you!
Answers
-
What exactly do you mean by
"I valued out the Material #s"
??
-
Saved all material number's as a value (copied and pasted as a value).
-
Do you have any of them that have a leading zero?
-
Is this comma a leading zero?
-
OK, so I realized they were not numbers. Converted in Excel, re-uploaded, resolved issue!
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!