I would like to know the easiest method for populating mailing address
information based on selection of data from a validation selection
list. In column A, I have a validation selection list with one of
several 2 digit city codes. For instance, CL for Cleveland. After the
user selects CL, I would like Cleveland to populate Column B, Ohio to
populate Column C, and 44312 to populate column C.

I appreciate any help!

Take a look VLOOKUP function in Help menu

"BrownsFan" wrote:

I would like to know the easiest method for populating mailing address
information based on selection of data from a validation selection
list. In column A, I have a validation selection list with one of
several 2 digit city codes. For instance, CL for Cleveland. After the
user selects CL, I would like Cleveland to populate Column B, Ohio to
populate Column C, and 44312 to populate column C.

I appreciate any help!

Use Data Validation for in-cell drop-down for selecting a city code and VLOOKUP
for the filling-in part.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

Since you already hav the DV list you can ignore the following if you choose.

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP


On 11 Jan 2007 10:58:40 -0800, "BrownsFan" wrote:

I would like to know the easiest method for populating mailing address
information based on selection of data from a validation selection
list. In column A, I have a validation selection list with one of
several 2 digit city codes. For instance, CL for Cleveland. After the
user selects CL, I would like Cleveland to populate Column B, Ohio to
populate Column C, and 44312 to populate column C.

I appreciate any help!