I need a formula by which if I enter a city name in a cell, the name of the state in which that city is situated will be displayed in the next cell.
For eg: if I enter Chicago in A1, then B1 should display Illinois.

I need it only for major cities

Is it possible to make a formula like that?...please let me know...