List in excel with more than one column

[Gilbertjoe]

EXCEL VER 2002
I have a column in my worksheet(worksheet1) that has project abbreviations in the cells. The cells are named as Projects and another worksheet(worksheet2)uses a data validation list that uses the list to select a project abbreviation (just a regular old list, nothing special). This works fine.

What I'd like to do is create another column next to my project abbreviations with the full project name so that the user can see the abbreviation and the full project name in the drop down list on worksheet2.
Once the user selects something from this list only the project abbreviation is stored in the cell.

 

[bitbuster]

Hello,

Dropdowlists in excel are only linked to 1 column.
You can however work around this. Add a column before your code and number each code from 1,2,3 to ...
Add a column after the description and concatenate the code and the description in it.
Now create a dropdownlist (forms toolbar) with the input range being the concatenated column. In the cell where you want the code to be stored use the vlookup function like this:

vlookup(<cell link>;<the range of your 4 columns>;2;0)

Regards,

Bitbuster