Excel Magic Trick #111: Build A Questionnaire

[tucuchee]

Suppose you created a questionnaire with drop-down lists for answer possibilities. If one of the possibilities is "other", that then requires the user to fill in an additional field which is only unlocked with that option. Is that even possible?

[tucuchee]

Suppose you created a questionnaire with dropdown lists for answer possibilities. If one of the possibilities is "other", that then requires the user to fill in an additional field which is only unlocked with that option. Is that even possible?

[ExcelIsFun]

I do not know about this topic. Try THE best Excel question site:

mrexcel[dot]com/forum

[reina360]

where exactly is your website to download the xcel format? I went on your you tube channel, but no dice//?

[ExcelIsFun]

Watch the vid that auto plays at the channel - it shows how to download.

[bmp06gti]

Can i use this code for a question for more than just A or B? like i wanted to make the possible answers to be "a,b,c,e,f,g)?

[Mynotoar]

Very cool :P. Still haven't quite got the hang of VLOOKUP, but I should get it after a few tries :).

[ExcelIsFun]

Watch the "Highline Excl Class" VLOOKUP videos (3 of them) and you will know 99% of what VLOOKUP can do. Please watch these because VLOOKUP is about the #1 question that employers ask in interviews that invlove Excel.

Once you watch them, you will then just answer:

"Yes! I can do VLOOKUP in my sleep!"

[Mynotoar]

Useful as it may be (I'll take your word for it :P) I'm not interested in pursuing a job in consultancy or IT, I'm thinking of heading down the psychological department. Failing that, I'd want to become a writer, failing that, I'd want to make videos (better than the pathetic excuses on my channel,) and failing that, I find a nice patch of concrete, lay down my moth-eaten hat and beg for money.

The latter sounds the most appealing.

[ExcelIsFun]

Psychological? A lot of stats! That means lots of Excel.

Patch of concrete? You still need a spreadsheet to track all the money you will bring in!

[Mynotoar]

Yeah, because most tramps are indeed learned in the arts of Excel. In fact, the tramp population are so fluent with Excel that in no time they have flawlessly executed spreadsheets to calculate their daily begging income and expenditure for venues, tip-cut-off gloves and patchy hobo jackets.

Anyway, I'd be using the IFERROR formula too much for Psychology, too many nutcases, too much error. :D.

[bmp06gti]

Can i use this code for a question for more than just A or B? like i wanted to make the possible answers to be "a,b,c,e,f,g)?

[soulsaver04]

5 stars

[ExcelIsFun]

Dear soulsaver04,

I am glad that it helps!

--excelisfun