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