changing data in range of vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
Back
Top