title: Referencing Drop Down list Value in other sheet
body: <p>I have a sheet with multiple drop down lists which select a certain text value.
  When I reference to these cells in another sheet, I get the number corresponding with the chosen value but not the value itself, ex. I chose a name in my dropdown list, it is the 2nd value in that list so I get "2" as a result in the other sheet when I reference this cell. </p>
  
  <p>I've tried the Value function but to no avail.
  How can I display the actual value in this new sheet instead of retrieving the number of the value in the list?</p>
  
  <p>Thank you for your time. </p>