Formula INDEX/MATCH is pulling wrong values. Does anyone have similar experience?

pavla70006 ✭✭
edited 03/16/21 in Formulas and Functions

Formula used:

Sheet it's pulling from:

Result: NO MATCH although the code exists exactly the same in both sheets.


  • Sam M.
    Sam M. ✭✭✭✭✭

    Hi pavla70006,

    Sometimes with MATCH you can put a 0 at the end and it helps find a definitive match to what you are looking for:

    =INDEX({Expected Date},MATCH([Course Code]@row,{eDL Code},0))


    I did some testing.

    Without the 0 I had the same error:

    With the 0:

    Sheet it’s pulling from:

    Hope it helps,


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!