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.

Assuming your list is sorted by state, you could use dependent data
validation lists, as described he

http://www.contextures.com/xlDataVal02.html

otinky wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html