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