trying to be clever
 

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

trying to be clever
 

Sounds like a job for Vlookup.

See Excel help for details.

--
Regards,
Tom Ogilvy

"Little pete" wrote in message
...
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