Dependant List Problem

Your data validation list in F2 is simply the name that the user picked in E2. That won't do anything.

This is the formula you want for F2 data validation list:

Formula:

Please Login or Register  to view this content.

Here are two more methods.
The first method converts the choice in the first drop down list to a "legal" name which has been previously defined by selecting each column and using Define from Selection.

The second method uses a table. The first choices are the table headers and the second choices are the items under each table heading. This method allows you to add columns to the table and the drop down lists automatically include the new column.

The table method involves creating names from the table and using an offset in the names so that offset isn't necessary in the Data Validation.

Understood. Now I tried creating names for columns but here on F2 I got a problem. Why?

You can't use E2 directly because defined names cannot have spaces. To use E2 that has spaces, you need to convert E2 to a "legal" defined name. You can do that with a table like this:

	K	L
2	Hot Beverages	Hot_Beverages
3	Cold Beverages	Cold_Beverages
4	Drinks	Drinks

With this table you can then in Data Validation, use list, use this formula that pulls the correct defined name relating to the value in E2:

Formula:

Please Login or Register  to view this content.