Index Match with some data returning as Invalid Data Type

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!