Forum Discussion
How to create drop down list but show different values in Excel?
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.
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.
the only reason I copied and pasted on 2 page to the right is so that i didnt have to add an addional column and mess up the formulas I already have in place. Riny_van_Eekelen