COPY FORMULA

[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

 

[Frank Kabel]

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

 

[Fernando Duran]

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

 

[Fernando Duran]

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