Having trouble using VLOOKUP formula in my Smartsheet

11/26/20
Accepted

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,

Helen

Popular Tags:

Best Answer

Answers

  • Helen PercyHelen Percy ✭✭✭✭✭

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

Sign In or Register to comment.