Look up data from one sheet

[Guest]

I want to type in a material number in cell A1 on sheet 1 and have the
information from cells A1:A3 on sheet 2 populate cells A2:A4 on sheet 1.

ex.

sheet 1
cell A1 is blank

sheet 2
A1=200209 A2=CLOSURE A3= TH

I WANT THIS INFORMATION TO POPULATE ON SHEET 1 WHEN I TYPE IN THE MATERIAL
NUMBER.

 

[Guest]

B1 explanation - If A1 is not blank then insert value from Sheet2 cell A1,
otherwise leave B1 blank.
So
B1 FORMULA: =IF(A1<>"",Sheet2!A1,"")
C1 FORMULA: =IF(A1<>"",Sheet2!B1,"")
D1 FORMULA: =IF(A1<>"",Sheet2!C1,"")