trying to be clever

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

Guest

have created a s/s which looks up a data validation list by using named
ranges and the indirect function. to make it easy for the users i am using
words in this data. however this information (the words) needs to get
converted into codes.

ie

Door 100
Wall 101
Window 102
Room 103

what i am hoping to do is for the user to select the word and then the
system to record the code.

To make it trickier i am using the Indirect function so depending on what
you select in the first list determines what you can select in the next.

thanks for the help
pete
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation - Create dependent lists 1
Retrieving Key value from dropdown 7
Programming to create a report from raw data 10
delete certain rows only 4
producing a list from a programme 5
Issue with INDIRECT function. 4
number to text 1
Can I... (trying to be clever with pivot tables) 0

Back
Top