Home > Forum Home > Developing Business Administration Solutions > Questionnaire on Excel help? ASAP! Share

Questionnaire on Excel help? ASAP!

Excel Help for Questionnaire On Excel Help? Asap! in Developing Business Administration Solutions


Forum TopicPost Reply Login

Questionnaire On Excel Help? Asap!

Rate this:
(3/5 from 1 vote)
AngryI 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!
 HELP- ASAP- Thankyou!!!
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Grateful
Rate this:
(3/5 from 1 vote)
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".
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Excel templates and solutions matched for Questionnaire on Excel help? ASAP!:

Solutions: Candidate Selection