I have a dropdown list created from data validation. I'm trying to create a dropdown list that shows the abbreviation and on the right it shows the name of the US state. When the state is selected, only the abbreviation will be displayed in the cell. I do not want to use macro. Is this possible?
I currently have over 300 rows and over 30 columns of data that I want to convert.
I currently have over 300 rows and over 30 columns of data that I want to convert.