data validation list from two columns

G

Guest

I have a list of every county, parish and borough in the US in a worksheet,
like this:

A B
1 HI Kauai County
2 HI Maui County
3 ID Ada County
4 ID Adams County
5 KY Adair County
6 KY Harlan County

I would like to create a data validation list so that a user can quickly
lookup county level data--accessed by an Index and Match formula. I hope to
accomplish two things:
1) not force the user to scroll through all 3,000 county names
2) keep seperate Washington County in TN from Washington County in GA, IL,
KY, etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation - List 1
Data Validation from a list - Always case specific? 2
Data validation: concatenate two separate ranges in the List? 3
Dynamic Data Validation List 2
Auto Complete a select from a data validation list 6
dropdownlist two columns 1
Matching data/columns from two seperate files 5
data validation list: how do i 'force' a user to enter data from the list? 4

Top