Vlookup function

Hello all,

I am looking for a formula that see's the week number, and therefore populates the period in the box above it

Everything is listed on this sheet below, each week has a corresponding period, all the way to the end of 2022

I tried using,

=VLOOKUP($[2]$3, {IN. Data Control (Dates) 2019-22 Range 2}, 4, false)


But it comes up no match

Suggestions?

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Jessica Howell

    I would use an INDEX(COLLECT formula instead!

    First you list the column with the information you want to bring back, then you list each column and criteria after it as a sort of filter.

    Try something like this:

    =INDEX(COLLECT({Period Column}, {Week Column}, $[2]$3, {Year Column}, $[2]$1), 1)

    Cheers,

    Genevieve

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!