No.
In L30, put the formula =IF($D30="","",'sheet3'!L30)
Then copy across (noting the absolute reference for the column in $D30 to
ensure it stays unchanged when you copy across).
--
David Biddulph

"Theo" wrote in message
...
I am trying to copy an array from one sheet to another sheet as part of a
conditional formula.
Something like =IF(D30="","",(L30:N30='sheet3'!L30:N30))
Any ideas?