If anyone can help me with this or try to point me in the right direction I
would be grateful. I am trying to type a specific number in one cell and then
have text appear in the cell below. Example cell c8 I type 3113 and in cell
c10 have Chicago, IL appear. Thing is I have about 200 different numbers
representing different city's and states, so next time cell c8 might be 3001
and then need cell c10 read New York, NY. Any suggestions, thanks in advance