In Excel I have a two-column list of codes in a worksheet named "Codes." The table looks something like this:
A Description A
B Description B
C Description C
I am using the 1st column (A,B,C) in cell validation so people can only choose A, B or C and we don't have any accidents caused by mistyping. So in my DV Settings tab I refer to the column containing ABC.
I would also like to have an input message that looks like the table above so people know what A means, etc. as they are in the drop-down.
Since the table is already all typed out, I hate to duplicate my efforts by retyping the codes and descriptions into the input message field. Is there a way to just refer to the codes and descriptions? That would save time, plus, if and when the codes get changed the input message would update also.
Any way to do this?