View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default changing data in range of vlookup

That sounds like Data Validation. Select the cell, go into DataValidation
and either remove it or amend it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Josie" wrote in message
...
I have created a spreadsheet using vlookup & I now need to amend some of

the
information in the range of data, however, when I try to change this I get
error message "The value you have entered is not valid. A user has

restricted
values that can be entered into this cell" Please can you advise how I can

do
this. Thanks