I want to create a dependant list on E2 and F2 cells. I have problem with F2 cell. Why I couldn't do it?
I want to create a dependant list on E2 and F2 cells. I have problem with F2 cell. Why I couldn't do it?
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.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Understood. Now I tried creating names for columns but here on F2 I got a problem. Why?
Last edited by zanshin777; 08-30-2015 at 01:03 PM.
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 2Hot Beverages Hot_Beverages 3Cold Beverages Cold_Beverages 4Drinks 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks