Currently I define data ranges and then tie them to cells using data verification. I then input data into the cells using a dropdown box allowing me to pick from the list. Works fine. Now there's a need to make it more complicated.
What's the easiest way to have the dropdown list show one set of values (e.g. employee names), but when a selected a corresponding value is input into the cell (e.g their social security number)?
What's the easiest way to have the dropdown list show one set of values (e.g. employee names), but when a selected a corresponding value is input into the cell (e.g their social security number)?
