View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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?