Excel 2007 : city - state formula

**aj_coolguy** · 04-29-2010, 06:20 AM

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...

**zbor** · 04-29-2010, 06:22 AM

You can do that with VLOOKUP formula.

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

You just need to define somewhere (table_array) all cities and states

**aj_coolguy** · 04-29-2010, 03:26 PM

could you please elaborate? sorry i'm not very good at excel....

**zbor** · 04-30-2010, 02:52 AM

Best way to ilustrate your problem is to upload some .xls example with desired inputs in outputs.

With generally asked question we can't do more than give general answer. Sorry

So best way would be to look somewhere how use VLOOKUP.. For example here:

http://www.youtube.com/watch?v=GZX2iXfqALs

It's just few minutes so try follow instructions and if you can't make it work please upload example workbook.