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.