I have created a questionnaire on excel. I am in the process of making a submit button so the information goes on to another page. However, when i select the information on the other page it comes up with the number item selected in the question. For example, if i select male or female, it would come up as 1 or 2. How can i change this so the word comes up instead of a number? Is there a function to do this? Need help ASAP!!! Thankyou for anyone who takes their time to help!
If you are using form objects for the questionnaire, then the options will be coming from some source ranges. If you attach a cell link to the form object, then it will return the index number of the option chosen. The destination sheet then needs to take in INDEX function with the index number of the option chosen against the source list range to return the text of that option. For example, index 1 would return "male" and 2 would return "female".