Lookup help (I think)

[SueN.Pools]

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!

 

[Bob Phillips]

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)

 

[Guest]

I'm confused, You type a name in Col B and if a match exists in Column A,
what is it you want to do?

Mike