"user has restricted values" in lookup
It sounds like the cell you're changing has data|validation applied.
You could hit
F5 (edit|goto or ctrl-g)
Special|data validation
to select all the cells with data|validation.
Then you could tab through them looking for the ones you want.
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!
--
Dave Peterson
|