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!