Excel Forum

Excel Magic Trick #111: Build A Questionnaire

See how to put the IF function inside a VLOOKUP function, add Data Validation, use an Array formula, unlock cells and protect the sheet all in order to create a Questionnaire form that automatically tallies the score. Protection Lock cells Unlock Cells Protect.

Got a Question? Ask it Here in the Forum.