Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Formula Errors with Index match

    ✭
    in Formulas and Functions

    I'm trying to get an index formula to look up the employee ID and return the project they are assigned to on another sheet. The issue is that if the ID is blank, its returning the first project in the list with no ID #. I thought the IFERROR would take care of that but it isn't. Any suggestions?

    =IFERROR(INDEX({Proj_Name}, MATCH([*]@row, {Primary Super_ID}, 0)), "")

    Here is the formula I have ^^

    · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭
      edited 01/06/25

      You could use an ISBLANK formula to say that if the ID is blank then to produce a blank result. So it would look something like this:

      =IF(ISBLANK([*]@row), "", INDEX({Proj_Name}, MATCH([*]@row, {Primary Super_ID}, 0)))

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions