Data Validation

R

rick2701

I am trying to establish an online form where a user could select a
address from a data validation drop down list. However, I can onl
seem to get the list to display a single cell, and the address is the
not formatted correctly for the form. Is there a way that a drop dow
list can return 3 cells as the selection, or is it limited to a singl
cell. :confused
 
G

Gord Dibben

Limited to contents of a single cell.

You could combine the address into one cell.

Assume street address in A1, City and State in B1, Zipcode in C1

In D1 enter =A1 & " " & B1 & " " & C1

Drag/copy down as far as you need.

Gord Dibben Excel MVP
 
Top