Forum Discussion

jasontindal's avatar
jasontindal
Copper Contributor
Jan 19, 2020
Solved

How to create drop down list but show different values in Excel?

Difficult one - I need to create a drop-down box that when I select the dropdown value, it returns an abbreviated word. I have a worksheet that has over 100 drop-down boxes but all the info is the sa...
  • Riny_van_Eekelen's avatar
    Jan 19, 2020

    jasontindal 

    Obviously, you already know how to do data validation as your schedule is full of it. What exactly do you want to return and where? You speak of "an abbreviated word" and "highlighted information in the 2nd page". You mean the yellow cells in columns L:M? The words are exactly the same as in column A (=basis for all your drop-downs). What's the purpose of the sequential number (1-29) in col M? 

     

    Perhaps you intend to write abbreviations in L1:L29 and have these displayed in columns B:G on "Sheet1", depending on the selections made. For example, select "Competitive Catalyst" from the drop-down and then return "CompCat". That could be tricky. So, please clarify your intentions.

Resources