Forum Discussion
Display the selected text as number on a drop down list
Hi Mishu
Unfortunately, you can't make it put a different value in the same cell, so the drop down would be in one column and the corresponding number value would be in another column.
So if you pick from the drop down in cell AE4, you then need a formula in AF4 (or out of the way to the far right) that has a formula to pick up the position of that item in the list = MATCH( AE4, Sheet2!$G$3:$G$75 , 0)
What you want is possible but only with getting into the VBA (Macro) side of things, which is a lot more complex to set up properly, e.g. be able to double click in AE4 and have a pop up box and be able to see the full description, pick one, and the resulting figure of 1 etc to be returned into AE4
HI Wyn Hopkins I'm having the reverse problem; I mean .. I need to display the selected number as text .... I have a number (response option) and I need to have the corresponding text (option1 caption, option2 ..) for different questions.
Response Option | Option1 Caption | Option2 Caption | Option3 Caption |
| 1 | Male | Female | |
| 3 | Less than 30 years old | from 31 to 40 years old | more than 41 years old |
| 1 | Daily | On shift |
Thank you !