Dependent cells

[beef44]

How do I make cells that are dependent on a given result in excel, so that if I for example write 1234 in cell A1 other cells are dependent on this cells value and changes to given result from a third cell?

Like this:
When i put in the data in cell A1 then the data in cell A2, A3 & A4 is put in automatically, drawn from the data in cell D2, D3 & D4.

So D2, D3, and D4 must in some way be linked to the result 1234 so my sheet knows that when 1234 is entered in cell A1 then A2 A3 A4 is filled with the data from D2 D3 D4.

Is it possible to do? And how do I do it?

 

[oldbrewer]

in A2 put =if($a$1=1234,b2,"") and copy down

 

[beef44]

in A2 put =if($a$1=1234,b2,"") and copy down

Sorry, i am quite a rookie in excel and cannot get the above to work.

In A2 i write the formula u posted above. But what do i have to put in the "".

Can you make a formula that i can copy and paste or somewhat near that?

A1 is the place i want to put the id: 1234
B1+B2 should then automatically change to a result i have in cell D4, D5 & D6.

Are u able to make the formula for that?

Thank you in advance - and sorry for my low level of knowledge in excel.

 

[beef44]

Sorry - D4 & D5 only.

 

[oldbrewer]

in A2 put =if($a$1=1234,d4,"") and copy down

when you copy this to A3 the D4 will change to D5

"" is the definition of a blank - you need this if $A$1 is NOT 1234