|
Look up data from one sheet
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. |
Look up data from one sheet
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,"") "BAKERSMAN" wrote: 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. |
| All times are GMT +1. The time now is 10:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com