Help with a VLOOKUP using an auto numbering column

I could really use some help. I am trying to use a VLOOKUP formula with an auto numbering column. I tried with and without a trim function but stil having issues.

Receives an #unparseable error - =IFERROR(VLOOKUP(TRIM([Event_ID]@row), {Onsite Feedback Form Range 3}, 4, false), "")

Doesn't return any information - =IFERROR(VLOOKUP([Event_ID]@row, {Onsite Feedback Form Range 4}, 4, false), "")


Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Connie Cochran

    Try wrapping a VALUE function around the row reference to ensure the number is being seen as numerical, like this:

    =IFERROR(VLOOKUP(VALUE([Event_ID]@row), {Onsite Feedback Form Range 4}, 4, false), "")

    Let us know if that worked!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!