changing data in range of vlookup
 

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

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