Excel Forum
Similar Content
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Multiply by True and False in Excel
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...
Sparkling Christmas Tree in Excel
Tutorial: How to make a wonderful sparkling Christmas tree in Excel. This method uses only formulas;...



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.