outlook help wrote
....
=IF(ISNA(MATCH($A5,[SDS.xls]NOW!$L$3,0)), IF TRUE then, IF FAlSE then)
then if true, copy cells n8:n12 and n14:n15 in workbook SDS to cell b5:g5
in
workbook wkly mgt?
If I've read your intent correctly,
Assuming the action if FALSE is to return blanks: ""
and the output range is instead B5:H5
(think there's a typo in your "B5:G5")
In book: wkly mgt
-----------
Put in B5:
=IF($A5<[SDS.xls]NOW!$L$3,INDIRECT("[SDS.xls]NOW!N"&COLUMNS($A$1:A1)+7),"")
Copy B5 across to F5
The above will return cells n8:n12 in book: SDS into B5:F5, if TRUE
Put in G5
=IF($A5<[SDS.xls]NOW!$L$3,INDIRECT("[SDS.xls]NOW!N"&COLUMNS($A$1:A1)+13),""
)
Copy G5 across to H5
The above will return cells n14:n15 in book: SDS into G5:H5, if TRUE
--
There's no need to use: MATCH($A5,[SDS.xls]NOW!$L$3,0)
if you're checking the match of a cell against another single cell range
Note that INDIRECT requires the "slave" book, SDS.xls to be open, otherwise
you'll get #REF! errors
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
|