If cell matches cell in another sheet, return value from a column in that other sheet

Im working on a formula that will compare my Client ID column from my current sheet current row, to my Client ID column on my second sheet (called Production Log). When the client ID matches, I want the check date column from my second sheet to be returned.

This is my formula. It is giving me an unparseable error.

=IFERROR(INDEX(COLLECT({Production Log 1st pr date},{Production Log Client ID},HAS(@cell,[Client ID]@row)),1)"no match")

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓


    You should be able to do this with just a simple INDEX MATCH formula such as:

    =IFERROR(INDEX({Production Log 1st pr date}, MATCH([Client ID]@row, {Production Log Client ID}, 0)), "no match")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!