Trying to tie a drop down list into creating a value in a neighbouring cell

WOW ! Thanks guys ... That's exactly what I wanted to do ! Much appreciated.

And yes I will alphabetically sort them when I've done the final list, just waiting for more data from the engineers.

Thanks again !