Timesheet #2

This one should be a bit more simple, (vlookups I think)

I have a list of clients, and client codes

so:

CODE_____CLIENT

001 Mr. A
002 Mr. B
003 Mr. C

And on the time sheets, we must put the client, and the code.

So

0004 Mr D

But we have to type that in manually (code and client)

Can we use a formula, so that when we type the client, the code will appear? Granted that the name will have to be exactly perfect.

Also, how it it possible, to make a list of possibles to appear, when typinig?

eg, if I type Graem

a list will appear underneath saying the possibilities.

such as

Graem
-Graeme A
-Graeme B
-Graeme C

ETC.