VLOOK to a diffrent sheet #NO MATCH

I'm getting the #NO MATCH error when cross referancing to a nother smartsheet file that has close to 20k rows, do you think this is causing the error. I looked up one of numbers and see it but still getting the #NO Match error. It is not finding any of my 500+ rows? Any thoughts here? First image is teh {Smartsheet BNI BU LIST.....Range 1}



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!