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.