Is there a way to create a two-column list to use in the Data Validation process in Excel 2010? have a list like:
PrjMgr Project Manager
RscMgr Resource Manager
But in the drop-down in the cell, to control data, I need both columns to appear as the user may not know what each ResourceID refers to.