Mixing 'on Error' and 'otherwise'?

[JBlackhole]

To all

Is it possible to "mix" on Error and otherwise? I am trying to find a value in a vector using a match function,

If the value is not found do an linear interpolation

Else

get the rank of the value  (in vector 1)

return a value at that rank in another vector

Attached test function which works if all the vectors are the same length but not with different length. It looks like the On error does; not quite work are it seems that the rank is always zero

[ValeryOchkov · Accepted solution]

To J B from all

[JBlackhole]

Thanks Valery. I have just spotted that and was going to post an updated wsheet. You beat me to it

[ValeryOchkov]

You welcome!

(1) - it is a vector not scalar!

I use in same cases the Trace Error command and the Return operator.