View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
theo theo is offline
external usenet poster
 
Posts: 66
Default Can I copy an array in a conditional formula

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?