vlookup

  • Thread starter Thread starter Peter Bailey
  • Start date Start date
P

Peter Bailey

I have a cell that gets its data via vlookup. How do I stop the user
overwriting data in this cell? if I lock the cell the vlookup wont work. I
tried data validation but that overwrites the formula.

regards
Peter
 
The VLookup formula should work, even if the sheet is protected. What
happened when you tried it?
 
Back
Top