Data validation in Excel - getting the Id, not Name
Posted on 2011-09-27
Here's what I want to do:
Let's say I have a named range with two columns:
For cell A1, I create a data validation of type List, so that the only acceptable values in A1 is One, Two or Three (i.e. any value in the "Name" column)
In cell A2, I make a reference to A1, so that it contains the corresponding Id of the selected value, i.e. 1 for One, 2 for Two, 3 for Three.
Is this possible WITHOUT MACROS? If the solution requires using a dropdown control instead of data validation, that is ok.