VLOOKUP function not working

Laetitia Lefrancois

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,

Laetitia

Paul Newcome

Try adding the final argument.

=VLOOKUP([Sheet Name]@row, [Overall Batch Release Status}, 2, false)

Laetitia Lefrancois

It Works! Thank you !!

Paul Newcome

Happy to help. 👍️