View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default "user has restricted values" in lookup

Hi,
Go to Data validation, you will see there the range and the value to be
entered, usually you use it to let's say for example nobody can enter a
negative number or less than ????.

if this helps please click yes, thanks

"smartgal" wrote:

I am trying to do a lookup and I'm getting the error, "user has restricted
values that can be entered into this cell." How do I know which cell is
restricted and what I need to do to unrestrict it? I have unprotected all my
cells, etc. Also, a vlookup done here previously worked just fine so . . .
at a bit of a loss.

Thanks!