Filtered List in Data Validation

[Saighead]

Hi,

Is there a way to make Excel display a filtered list based on a Data Validation range? For example:

Sheet1:

Column A　　　　　　　　　　　　Column B - data validation set to List (Sheet2!$B$1:$B$100)
store1
store2
store3

Sheet2 (contains a list for Data Validation of column B on Sheet1):

Column A　　　　　　　　　　　　Column B
store1　　　　　　　　　　　　product1
store1　　　　　　　　　　　　product2
store1　　　　　　　　　　　　product3
store2　　　　　　　　　　　　product4
store3　　　　　　　　　　　　product5
store3　　　　　　　　　　　　product6

So, when I have "store1" in Sheet1:A1, I need Excel to filter the Validation List based on this value and display only "product1", "product2", and "product3" in the dropdown list for cell Sheet1:B1. Is it doable?

Also posted here

[Richard Buttrey]

Hi,

I think you're looking for dependent drop down lists. There are a couple of ways.

Mosey on over to Debra's site where you'll learn everything you ever need to know about dependent lists (and more...)

https://www.contextures.com/xlDataVal02.html