Creating a pick list dependent on another pick list

- [Voiceover] In this worksheet, we're seeing some entries…over in column A, some column headings.…Whoever's entering the data here is gonna have a lot…easier task if no State entry is typed here.…In other words, they emerge from a pick list.…And a lot easier if no City names need to be typed here.…Now, if someone chooses Arizona, for example, the city names…that are going appear here, we want to be like what we see…over here in column K.…We'd like to have the pick list in column D be dependent…upon the entries in column C.…

And we could do this, and it involves using an…unusual function called Indirect.…Let's begin by setting up a pick list for column C.…Now, as always when you're setting up pick lists,…it's best to have the pick list source data be nearby,…so you can see it easily and check it out and so on.…Eventually, this data to the right here, it covers…not all states but quite a few.…We will move this onto a different worksheet probably.…We could hide the columns.…The ideas is we don't want it to be out there…