I have set up a spreadsheet for drivers with their unique code. This unique
code is quite long. So what I require, is when the drivers name is put in
the cell, the cell opposite automatically puts the drivers unique code in.

example:
a b
Driver 1 5456456434dfsf4545
Driver 2 548982112123dffd55