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

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.