COPY FORMULA

  • Thread starter Thread starter Fernando Duran
  • Start date Start date
F

Fernando Duran

Hi, I'm tried to copy a formula in another five cells. The formula is
there, but doesn't work as th original, it give me zero results.. any
idea why?
=IF(ISNA(INDEX($C$3:$C$5000,MATCH(F19,IF($B$3:$B$500=F3,$A$3:$A$500),0)
)),"",INDEX($C$3:$C$5000,MATCH(F19,IF($B$3:$B$500=F3,$A$3:$A$500),0)))

doesn't read the cells as in the original copy of the formula, which
is working fine in 3 cells.

thanks
 
Hi Fernando
difficult to say, but some ideas
- You're using F19 and F3 as conditions (maybe they are altered during
your copy)
- have you entered the formula as array formula?

Frank
 
Hi Frank, yes, the F19 changed to F20 or F21, differents cells with
differents values entered by the user, the F3 is permanent, always the
same value. I used ASAP utilities to re-build the formula as an
array...

Fernando
 
Hey Frank, problem solved..
thanks

Hi Fernando
difficult to say, but some ideas
- You're using F19 and F3 as conditions (maybe they are altered during
your copy)
- have you entered the formula as array formula?

Frank
Click to expand...
 
Back
Top