Can I copy an array in a conditional formula

T

Theo

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?
 
R

Roger Govier

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.
 
D

David Biddulph

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).
 
Top