Hi.

I have a formula that works just fine, as long as i paste the values
from the original list and not type the numbers in.

There are no hidden spaces (that I know of), but when I type the same
value that I have in my orignial list, the formula gives me an error
(#N/A). When I copy and paste values (from the original list) it works
just fine.

Any clues?

(an array formula)

=INDEX(TSCA_REQ,MATCH(1,(B202>=TSCA_MIN)*(B202<=TSCA_MAX),0))