Share via

Data Validation Drop Down Menu and Return a Different Value

Anonymous
2018-06-29T02:37:46+00:00

Hi,

I want to create a data validation list that has certain values but then return a different value. Is this possible without using a VBA? For example, within a drop down list for countries I want the list to include (United States, United Kingdom) but when you select United States, I want the cell to say (U.S.)

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. OssieMac 48,001 Reputation points Volunteer Moderator
    2018-06-29T04:26:07+00:00

    I don't believe that you can do that.

    You can use a column for the Data Validation and then in the adjacent column you can use VLOOKUP to insert the abbreviation for the selected value.

    Was this answer helpful?

    0 comments