Abbreviation conversion

B

borchesz121

I need to be able to convert city abbreviations ex: CHI to Chicago, IL.
The way I have it set up in spreadsheets right now is:

I have on Worksheet 1 - in Column A, Row 1 = CHI
in Column B, Row 1 = Chicago,
IL
in Column A, Row 2 = ATL
in Column B, Row 2 = Atlanta,
GA. and so on....

On Worksheet 2 -

This worksheet is my lane worksheet where I have an Origin and
Destination
- in Column A, Row 1 = CHI (origin)
- in Column B, Row 1 = ATL (destination)



I need a formula that will convert the abbreviation cities into the
full name cities, this will need to convert them so I can pull them
into a "worksheet 3"....

ex: - in Column A, Row 1 = Chicago, IL
- in Column B, Row 1 = Atlanta, GA

Thanks,

Scott
 
B

BenjieLop

borchesz121 said:
I need to be able to convert city abbreviations ex: CHI to Chicago, IL.
The way I have it set up in spreadsheets right now is:

I have on Worksheet 1 - in Column A, Row 1 = CHI
in Column B, Row 1 = Chicago,
IL
in Column A, Row 2 = ATL
in Column B, Row 2 = Atlanta,
GA. and so on....

On Worksheet 2 -

This worksheet is my lane worksheet where I have an Origin and
Destination
- in Column A, Row 1 = CHI (origin)
- in Column B, Row 1 = ATL (destination)



I need a formula that will convert the abbreviation cities into the
full name cities, this will need to convert them so I can pull them
into a "worksheet 3"....

ex: - in Column A, Row 1 = Chicago, IL
- in Column B, Row 1 = Atlanta, GA

Thanks,

Scott
Click to expand...

ASSUME that your table range in Sheet 1 is A1:B100.

Enter the following formula in Sheet 3, Cell:

A1: *=vlookup(Sheet2!A1,Sheet1!$A$1:$B$100,2,0)*

B1: *=vlookup(Sheet2!B1,Sheet1!$A$1:$B$100,2,0)*

Regards.
 
Top