IF Formula

D

Dave

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
 
R

Roger Govier

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
 
H

hmm

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.
 
Top