Index Match with some data returning as Invalid Data Type

Coyster

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?

Chris McKay

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