Morning
Have created various dependent lists using the INDIRECT function. What I
need is for the user to select from the list looking at the wordy name but
once selected I want the system to enter the code ie

Asset Code
Door 101
Wall 102
Floor 103


So when they select the 'Door' the system enters in '101' rather than the
word 'Door'

Help on this would be great.

Cheers Pete