Max,
Thank you so much for all of your help. You have been wonderful and have
helped me move along with this.
"Max" wrote:
From OP's email note:
....
=IF($A9=[SDS2005CR.xls]we"&BU7&"!$L$3,INDIRECT("[SDS2005CR.xls]we"&BU7&"!N"&
COLUMNS($A$1:A6)+7),"") but got an ERROR.
Think you forgot to wrap the INDIRECT(...) around the 1st part of the
formula in the implementation:
.... $A9=[SDS2005CR.xls]we"&BU7&"!$L$3 ...
Try instead:
=IF($A9=INDIRECT("[SDS2005CR.xls]we"&BU7&"!$L$3"),INDIRECT("[SDS2005CR.xls]w
e"&BU7&"!N"&COLUMNS($A$1:A6)+7),"")
If the reference cell: BU7
(which presumably houses the week#'s: 121,128, etc)
needs to remain *constant*
when you copy the formula across,
change BU7 to $BU$7
(the dollar signs will make the cell ref absolute)
Hope the above helps !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
|