IF Formula
 

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

IF Formula
 

Hi Dave

If your complete list is in Sheet1 columns A and B, then in sheet2 cell
B2 enter
=IF(A2="","",VLOOKUP(A2,Sheet1!A:B,2,0))
and copy down

--
Regards

Roger Govier


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

IF Formula
 

Keep an alphabetical list of drivers in, say, column A, and their
corresponding codes in column B. Then type the following formula in an empty
cell, say D1:

=LOOKUP(C1,A:A,B:B)

(This expression looks in column A for the value in C1, then returns the
value to the right in column B.)

Copy to all desired cells in column D. In column C the drivers will enter
their names, and to the right in D will appear the codes.

"Dave" wrote:

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