Filtering data and validating data in excel

The best thing about using a table is that as you add or remove items from your list, your data validation list will update automatically.Note: The following examples use the Custom option where you write formulas to set your conditions.

After you select a Region, the drop down list in column C shows the customers in the selected region.

Go back and select a different region, and the existing customer name will be cleared. Clear Contents End If End If exit Handler: Application.

You can limit the choices in a drop down list, so that it only shows items related to the selection in another cell.

In this example, a region is selected in column B, and only the customers in that region will appear in the drop down list in column C.

I've been trying to find a way of doing this with dependent dropdowns, but I am yet to be successful with my specific tables.

In essence I'm looking to create a validation list based on a "filtered" results list from another table.

To block changes to the first list, you can change the data validation formula, so the list doesn't work unless the second cell is empty.

Instead of just referring to the Produce range for the Produce Type drop down, the formula will check for an entry in the Item column.

These are structured tables: Table1 (with static values to be "filtered" ) id From Table1 Related Option From Filtered Dropdown List 2 Item AA (dropdown lists: Item AA, Item AAA, Item CC) 5 Item XY (dropdown lists: Item XY, Item XYZ) 2 Item CC (dropdown lists: Item AA, Item AAA, Item CC) 3 Item ZZ (dropdown lists: Item ZZ) The thing is that I don't know where to start with this, specifically with how to create that "filtered list" within the validation list formula.

It's one thing to return a single text value, there's a lot of options for that, but I haven't found how to return a vector with the multiple filtered values. Although this is more comprehensive, I can't seem to use it as a validation List, only on a cell while issuing CSE, which returns just the first value.

With dependent drop down lists, problems can occur, if someone goes back to the first list, and changes it.