How to Create an excel dropdown list that displays text with a numeric hidden value <p>I am trying to create a drop down list that displays text with a hidden numerical value attached. Then I will have a standard formula on the same row that calculates a value based upon the hidden value selected.</p>