Look up data from one sheet

B

BAKERSMAN

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.
 
K

Kevin

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,"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search cell value in same column 3
How to delete ALL cells containing the same data 0
How to delete ALL cells containing the same data --- REVISED 0
Excel does not accept text format! 0
VLOOKUP??? 2
Filtering of data in a master excel sheet from multiple sheets 3
Copy Data from One sheet to Different Sheets 1
How to update data from multiple sheets to one specific sheets 4

Top