Lookup help (I think)

S

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!
 
B

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)
 
M

Mike H

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
 
Top