You can have a defined range with two or more columns, but that won't show
up in Data=Validation using the list option. You might want to look at the
Control Toolbox Toolbar Combobox or Listbox.

When an item is selected
in the dropdown list only one of the columns data is displayed in the
cell.

It is unclear if you are saying this is what you want, or you are
complaining that this is what happens and not what you want. It certainly
is what happens and there is no way around that unless you use code to
interpret the selection and write a concatenated string of the column values
to the single cell or write the row in the combobox dropdown across multiple
cells.

--
Regards,
Tom Ogilvy


"Pat" wrote in message
...
Can anyone tell me if it is possible to have two or more columns in a
defined range. I want to have a dropdown validation list where two or more
columns of data is displayed on the dropdown list. When an item is
selected
in the dropdown list only one of the columns data is displayed in the
cell.
Is this possible and how is this accomplished?
Or if there is a different approach I should go down please let me know.

Thanks
Pat