#1
|
|||
|
|||
Best way to populate drop down from a large number of choices
So I'm trying to create a drop down list but it would have around at least 1000+ entries. To make this easier I wanted to create several smaller categories and have the correct drop down populate based on a previous cell's entry. To make sure this is making sense:
-the 1000+ entries are locations across the world -I've added each location in lists/tables for each country -User will select the country -I'd like the next cell to populate a drop down list containing only the locations in the country selected. -if the country the US, it is further divided into states (also user supplied) obviously using nested if statements will be minimum 50 statements deep. To the more experienced people (pretty new to doing this level of thing in excel), what would you recommend using? I was looking at VLOOKUP but I've never used it and it doesn't seem like it is the right option. If I'm wrong please let me know! Thanks in advance. |
#2
|
||||
|
||||
Hi
try using dependent drop-down lists
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Quote:
|
#4
|
||||
|
||||
Most welcome. Don't forget to format your lists as tables. It will save time in the future
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a document which drop-down list cascade to further set choices | sfieldes | Word | 1 | 01-08-2019 09:39 PM |
Using a Drop Down list to populate a cell with multiple choices, Word 2010 | Barehands | Word VBA | 3 | 04-04-2018 05:11 AM |
Drop down lisr with multiple choices | Richard121 | Excel | 1 | 02-17-2015 08:30 AM |
How to synchronize the choices on several identical drop down menus | liyproswell | Word | 2 | 12-11-2014 06:08 AM |
Populate a table based on choices from drop down menu | Xaand | Word VBA | 0 | 02-25-2014 11:08 AM |