changing data in range of vlookup

[Guest]

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

 

[Bob Phillips]

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

--

HTH

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