Custom data type

[excelishard69]

I'm looking to create a custom data type and incorporate it into a dropdown box for easy selection.

ex. I want a type "answer" to represent numerical selections (0,1,2) as strings (Always, Usually, Never), and again incorporating the data type into a dropdown to select. Thanks for the help, if any!

[martindwilson]

data list for validation say A1 Always, Usually, Never
in another cell sat D1 =lookup(a1,{"Always","Never"," Usually"},{0,2,1})

[excelishard69]

Looks good, but is there a way to do this all in one cell, for organizations sake? I should have been more clear, I want the string "Always" to also represent the integer 0. This does that, but kind of screws my sheet by taking up 2 cells.

[martindwilson]

hide the column? dont forget it a spread sheet not a work of beauty or put the formula on another work sheet and refer to it

[excelishard69]

True, thanks a lot.