VLOOKUP function not working

Hi All,

I am struggling with the VLOOKUP function. I am exporting a report in an excel sheet on a weekly basis and reupload this report on Smartsheet to have the fix data per week. I created another sheet where I use the VLOOKUP function to extract the data from this weekly sheet. However, the VLOOKUP function does not always work (sometime it does) giving me or the incorrect results or #NOMATCH.

Any clue what is happening?

Weekly exported sheet:

Thanks for your help,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!