paste value vs type value (formula not working)

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

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))
 
HI Jeremy
If its an ARRAY Formula, you must press Control-Shift-Enter,
Try it and see
Good Luck
Cimjet
 
Back
Top