Having trouble using VLOOKUP formula in my Smartsheet


Hello Community,

I have been trying to use VLOOKUP to cross check a screening date to what screening number was performed on that date, or within the date range; though I haven't been able to make it work! Please can you help me with what I need to do to make it work. My formula is:

=VLOOKUP([Date of stock switchover]25, {MOA1 Screening weeks Range}, 1, false)

This is a snip of the Screening weeks Smartsheet used for {MOA1 Screening weeks Range}:

And here is a snip of the main Smartsheet the formula is in:

When the User enters the date in the 'stock was switched over' column, the Screen Number found from within the MOA1 Screening weeks Range is what I would like to be automatically filled in via the formula.

Your help will be greatly appreciated.

Many thanks,



Best Answer


  • Helen Percy
    Helen Percy ✭✭✭

    Thank you very much KDM for your comment and solution 😁 It worked 👍️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!