Can I copy an array in a conditional formula
Hi Theo
You can't do that with a formula.
You would have to have the formula in each of the 3 cells, e.g. in cell
L30
=IF(D30="","",'sheet3'!L30)
and modify for the other 2 cells.
--
Regards
Roger Govier
"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?
|