The same formula doesn't work again?

H

Hru48

Hey all,

I have a workbook which contains allot of data which is all brought
together on a front sheet via a drop down box and this formula:

=INDEX(Data2!$C$2:$C$325,MATCH(INDEX(Reference!$B$2:$B$7,Reference!$C$9,1),IF(Data2!$B$2:$B$325=
$A9, Data2!$A$2:$A$325),0))

its works perfectly... until I copy the workbook and refreash the data
automatically.

Does anyone know if I have to do something to activate this formula
again? or can anyone think of a reason why it has stopped working when
everything seems to be the same?

Many thanks,

Hayley
 
P

pdberger

Hru48 --

In the past, when I've tried that, the formula in the new workbook looks to
data in the old workbook. Since that old one typically isn't open and/or
available, I get error messages.

I haven't been able to figure it out -- maybe the smarter people in the
forum can do that. I've just had to use brute force to rewrite the affected
formulas.

Sorry I can't help more -- maybe that can point you in the right direction.
 
Top