Abbreviation conversion
 

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


--
borchesz121
------------------------------------------------------------------------
borchesz121's Profile: http://www.excelforum.com/member.php...o&userid=17824
View this thread: http://www.excelforum.com/showthread...hreadid=385375

borchesz121 Wrote:
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

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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=385375

Thanks for the help


--
borchesz121
------------------------------------------------------------------------
borchesz121's Profile: http://www.excelforum.com/member.php...o&userid=17824
View this thread: http://www.excelforum.com/showthread...hreadid=385375

You're welcome ... thanks for the feedback.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=385375