Forum Discussion
jj2525
Apr 09, 2025Copper Contributor
How to set Data Validation for VLOOKUP and row dependent formulas?
Hi, I'd like to use data validation to effectively 'lock' my formulas in place, so that any accidental edits to a cell that don't align with the correct formula for that column will be flagged. Howev...
HansVogelaar
Apr 09, 2025MVP
I don't think you can use Data Validation for that purpose.
- Select the cells that the users should be able to populate/edit.
- Press Ctrl+1 to activate the Format Cells dialog.
- Activate the Protection tab.
- Clear the Locked check box.
- Click OK.
- Activate the Review tab of the ribbon.
- Click Protect Sheet.
- If you wish, enter a password that will be needed if you want to unprotect the sheet later on. Don't forget the password!
- Click OK. If you provided a password, you'll have to enter it again as confirmation.
- Save the workbook.