From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,500 courses taught by industry experts.

Creating a pick list dependent on another pick list

Creating a pick list dependent on another pick list - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Creating a pick list dependent on another pick list

“

- In this worksheet, 2 we're seeing some entries over in column A, 3 some column headings. 4 Whoever's entering the data here is going to have 5 a lot easier task if no State entry is typed here. 6 In other words, they emerge from a pick list 7 and a lot easier if no City names need to be typed here. 8 Now, if someone chooses Arizona, for example, 9 the city names that are going to appear here, we want to be, 10 like what we see over here in the moment in column K. 11 We'd like to have the pick list in column D 12 be dependent upon the entries in column C. 13 And we can do this 14 and it involves using an unusual function called indirect. 15 Let's begin by setting up a pick list for column C. 16 Now, as always, when you're setting up pick lists, 17 it's best to have the pick list source data be nearby 18 so you can see it easily, and check it out, and so on. 19 Eventually, this data to the right here, 20 that…

Contents