Simple V Lookup Not Pulling in Values

MegBurns23 ✭✭✭
edited 07/06/23 in Formulas and Functions

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!?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!