look up tables - help?
Posted by daveu on August 22, 2001 12:30 PM
Is there a way attaching a look up table or list to selected cells within a sheet. Much in the same way as you can view and select from a list using 'pick from list'. In this case however I want the list to be on a separate sheet and to be able to select an entry from it. What I'm trying to do is constrain or force the data enterer to select a value from a specified list.
thanx