Automating Address Information based on selecting data via a validation list

B

BrownsFan

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!
 
G

Gord Dibben

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
 
Top