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

" wrote:

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!