I've created a drop down list of companies and I want a formula that will
display the relevant details (entered over a number of cells) when I select
one of them. I've been using the below formula which I know is incorrect but
might give you an idea of what im trying to do:

=IF(A2="OMD", C2=Sheet3!D2:D8)

I know you have to enter a value if false aswell but I'm really stuck here.
Also I need to be able to select another value in A2 and have it return
different results.

Help please!