Index Match with some data returning as Invalid Data Type

Options
Coyster
Coyster ✭
edited 12/09/19 in Formulas and Functions

I'm using an Index match to pull a certain number. In this column I will get a successful return of a few number then the Error then more correct numbers. 

Thing is, they are all pulling from the same data set (from an API), and using the same parameters and search values. 

Why am I getting the Invalid Data Type error?

data error smartsheet.PNG

Tags:
· Share on FacebookShare on Twitter

Comments

  • Chris McKay
    Chris McKay ✭✭✭✭✭✭
    Options

    Hi Coyster,

    Try wrapping the whole thing in a VALUE function and see if that helps, e.g.:

    =VALUE(INDEX({Index Range}, MATCH(value, {Match Range}, 0)))

    Kind regards,

    Chris McKay

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!