in the IF function is there anyway that i can have the 'if true' section of
the formula copy the values in another workbook in specific rows. In other
words,

=IF(ISNA(MATCH($A5,[SDS.xls]NOW!$L$3,0)), IF TRUE then
copy cells n8:n12 and n14:n15 in workbook SDS to cell b5:g5 in workbook wkly
mgt?

Brigida