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


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=553346