Definitely consider using AutoFilter. It can generate a pull-down (
alphbetic order) that will very rapidly allow you to get to the data of
interest.

see:

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


--
Gary''s Student
gsnu200706


"Thad" wrote:

I need help setting up a drop-down list...I'm close to figuring it out, but
it still does not work the way I need it to. Here is what I need:

I have a list of several thousand cities in Column A (and there are several
blank cells in between the list of cities in Column A). I have information
in Column C that corresponds to the individual cities listed in Column A. I
want a drop-down list at the top of Column A that will allow me to select a
specific city, and once selected, will bring me to that individual city and
its corresponding info in Column C. Can someone please assit me? Thank you!