Join Dennis Taylor for an in-depth discussion in this video Creating a pick list dependent on another pick list, part of Excel Tips Weekly.
- [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…
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.