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