Can we select one value from list & have a series of values populated from a another

Can we select one value from list & have a series of values populated from a another

Hi


I'm new here and have only a little knowledge on Excel.. and trying to get good hold on it..


I have database where.. The first sheet have got 4 rows ( dashboard kind of a setup ) entered and when we hit save.. it will send this data into the second sheet into 4 columns..


Sheet 1:


OrderID: 3432
Salesman: jack
Product no: 920
Qty: 9


SAVE - Button ( when we hit on this the data is saved into the next sheet )




Sheet 2:


OrderID Salesman Productno Qty
3432 Jack 920 9




Can I enter the orderId on sheet one and have rest of the data populated if its already existing in the sheet2?


Like orderID can be a list from which when I select 3432 it should bring up Salesman, Productno and Qty related to that which was saved already..




If I can get a lead I will try working on it.. Please give me your suggestions.. Thank you

When you say saved, do you mean separate workbooks, or separate cells on Sheet1? If the latter, what is the layout?