Data From A List

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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
 
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.
 
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
 
Thanks Gord!!

Gord Dibben said:
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
Click to expand...
 
Back
Top