How to make a drop-down box populate fields of data

[cory0789]

I have a drop down box that I need my selection to populate the rows of data on the order sheet from the master sheet... For Example

Drop Down Box includes Apples, Oranges, Pecans, Grapes

The master list has hundreds of products but when I enter a order number only certain products populate into the dropdown box...

So in the master sheet column A=Order Number, B=Product, C=Price, D=Quantity, E=Location

I need a complicated vlookup/hlookup that I cannot figure out or a macro that will input the data from master list into the order sheet...

I select Apples on the order sheet, then in the Price column on the order sheet say A33 I need the price of the Apples from Order number 989 only to populate there. in B33 I need Quantity, and C33 I need Location and so on...

Can someone please help me figure this out I have been trying to get this working for about 3 days with no progress!!!

TIA!!

 

[suitcase_livin]

Excel Dependent Drop-down Lists - Easy Excel Tutorial

I believe what you are talking about is cascading drop down lists- see here. It is very simple with the indirect function.

 

[cory0789]

No, i need the other data to populate based on the one drop down list selection throughout the row...