Create a list of numbers and names in M1:N20 say and use

=VLOOKUP(A2,$M$1:$N$20,2,False)

adjust the last row to suit.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
ups.com...
I am constatly entering client numbers and names in an excel
spreadsheet. What i would like to do it have a fomula in column b that
will return the client name that i type in column a. I could have a
master list of client to lookup from. Can someone please help me with
this. Thanks!