Display range of cells

[Guest]

Does anyone know how....

I can display a range of cells, if an if statement condition is met
so

if e1=e2 then
i need to display a1:d1 into a different range

 

[JE McGimpsey]

One way:

Select 4 cells across, say J1:M1. Array-enter (CTRL-SHIFT-ENTER or
CMD-RETURN):

=IF(E1=E2,A11,"")