Excel Dropdown/Validation based on another list

[ORN99]

Hi everyone,

I have a list of Products and associated Customers in sheet2. Sheet1 is an excel sheet where I take data via validation from column one (products) and I need the form to update with the data from column 2. Then I need to reference the other data points in each record.

e.g.
Product1 Customer1 Price1
Product2 Customer2 Price2
Product2 Customer3 Price2
Product2 Customer4 Price2
Product3 Customer5 Price3

Since different users are going to be using this, I am looking to make it as easy as possible, i.e. lookup or dropdown boxes. Currently, I have a validation setup for Products linked to the "table" then the customer cells have vlookups associated with the products. But when there are more than one customer associated with a product, I don't have access to them. Is there a way to place a drop down/validation for the customers to only show based on the product selection?

Thanks!

 

[SkipVought]

One of the things that you can do without VBA coding is to use a Pivot Table layed out as follows according to your example...

Put Headings on your columns - Product, Customer, Price

Drag Product to the Page Field

Drag Customer to Row Field

Drag Price to Data Field and SUM.

Now a user can select a Poduct and see the corresponding Customers and Prices. VOLA

Of course, there's more to your problem, no doubt.

But I hope tha this helps Skip,
Skip@theofficeexperts.com

 

[Wray69]

You can do just a simple vlookup off of the validation list.
something like =vlookup(a1,DATA RANGE,2,false) asuuming your validation list is in cell A1...

Hope this Helps...

Regards -

Wray