WHat I am trying to do is Type in a name of a Client in a cell and have the
adjacent cell automatically enter a specific client number....

For example.... if on cell A2 I type in "Smith" I want A3 to read "100".

I have a list of names and client numbers..... I have tried LookUp... but to
no avail.

Any help?

Thanks

Well, you need to show us your formula, for starters.

Tyro

"Steve" <(E-Mail Removed)> wrote in message
news:E977F61D-B06C-4E81-9D1F-(E-Mail Removed)...
> WHat I am trying to do is Type in a name of a Client in a cell and have
> the
> adjacent cell automatically enter a specific client number....
>
> For example.... if on cell A2 I type in "Smith" I want A3 to read "100".
>
> I have a list of names and client numbers..... I have tried LookUp... but
> to
> no avail.
>
> Any help?
>
> Thanks

Use VLOOKUP.

Pete

On Feb 20, 11:33*pm, "Tyro" <T...@hotmail.com> wrote:
> Well, you need to show us your formula, for starters.
>
> Tyro
>
> "Steve" <St...@discussions.microsoft.com> wrote in message
>
> news:E977F61D-B06C-4E81-9D1F-(E-Mail Removed)...
>
>
>
> > WHat I am trying to do is Type in a name of a Client in a cell and have
> > the
> > adjacent cell automatically enter a specific client number....
>
> > For example.... if on cell A2 I type in "Smith" I want A3 to read "100".
>
> > I have a list of names and client numbers..... I have tried LookUp... but
> > to
> > no avail.
>
> > Any help?
>
> > Thanks- Hide quoted text -
>
> - Show quoted text -

I have used If(A1="Joe",100,if(A1="Bob",101)) BUT that only works for 7 or 8
entries...... I have 30 Plus so I need the equivalent function on a grander
scale.

Thanks for any input.

"Tyro" wrote:

> Well, you need to show us your formula, for starters.
>
> Tyro
>
> "Steve" <(E-Mail Removed)> wrote in message
> news:E977F61D-B06C-4E81-9D1F-(E-Mail Removed)...
> > WHat I am trying to do is Type in a name of a Client in a cell and have
> > the
> > adjacent cell automatically enter a specific client number....
> >
> > For example.... if on cell A2 I type in "Smith" I want A3 to read "100".
> >
> > I have a list of names and client numbers..... I have tried LookUp... but
> > to
> > no avail.
> >
> > Any help?
> >
> > Thanks
>
>
>

You need a couple of things for a VLOOKUP formula.

A table with the values and a cell with the value to lookup.

On Sheet2 in A1 you have a title Client Name then a list of names below that to
A100........in B1 you have a title Client Number and a list of numbers to B100

In Sheet1B1 enter this formula =VLOOKUP(A1,Sheet2!$A$2:$B$100,2,FALSE)

Enter a name in A1 and see the number come to B1

If not too many names perhaps look at creating a Data Validation dropdown
selection list for the names.


Gord Dibben MS Excel MVP

On Wed, 20 Feb 2008 15:25:01 -0800, Steve <(E-Mail Removed)>
wrote:

>WHat I am trying to do is Type in a name of a Client in a cell and have the
>adjacent cell automatically enter a specific client number....
>
>For example.... if on cell A2 I type in "Smith" I want A3 to read "100".
>
>I have a list of names and client numbers..... I have tried LookUp... but to
>no avail.
>
>Any help?
>
>Thanks

Thanks Gord!!

"Gord Dibben" wrote:

> You need a couple of things for a VLOOKUP formula.
>
> A table with the values and a cell with the value to lookup.
>
> On Sheet2 in A1 you have a title Client Name then a list of names below that to
> A100........in B1 you have a title Client Number and a list of numbers to B100
>
> In Sheet1B1 enter this formula =VLOOKUP(A1,Sheet2!$A$2:$B$100,2,FALSE)
>
> Enter a name in A1 and see the number come to B1
>
> If not too many names perhaps look at creating a Data Validation dropdown
> selection list for the names.
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 20 Feb 2008 15:25:01 -0800, Steve <(E-Mail Removed)>
> wrote:
>
> >WHat I am trying to do is Type in a name of a Client in a cell and have the
> >adjacent cell automatically enter a specific client number....
> >
> >For example.... if on cell A2 I type in "Smith" I want A3 to read "100".
> >
> >I have a list of names and client numbers..... I have tried LookUp... but to
> >no avail.
> >
> >Any help?
> >
> >Thanks
>
>