Dropdown list with two columns

[dallen43]

Using Excel 2003...

Our users need to enter a code "01" or "02" in a column. I know I can use validation and create a dropdown with these two values.

But to make it easier for our users, I would also like to display the values these codes represent, "01 Return to Vendor" and "02 Destroy for Allowance". The value in the field must return only 01 or 02 not the description.

I hope I've made myself clear.

Thanks in advance,
Deb

 

[Gavona]

Using validation then the dropdown would include the text and another column would have to be used for the code. Use a formula like
=if(istext(A1),left(A1,2),"")
or
=if(istext(A1),left(A1,find(" ",A1)-1),"")

More than that will require VBA, I believe - forum707

Gavin

 

[DaveInIowa]

How about placing the value/description combinations in the Data Validation -> Input Message?