Excel 2007 drop down lists

I would like to create a drop down list of number that, when selected, will
automatically fill out the the next cell with a name i.e.

I select No. 120 and the next cell automatically fills out the name as being
Angela9520. How can I do that? Ostensible I want to select a number and
have the name associated with that number appear in the next cell!

I don't have 2007 but I think you can use VLOOKUP.

Something like this in B1 =VLOOKUP(A1,J1:K1,2,0)

Where A1 is the drop down and B1 has the formula and J is a list of the
numbers in the drop down and K is the corresponding names associated to that
number.

HTH
Regards,
Howard

"Angela9520" wrote in message
...
I would like to create a drop down list of number that, when selected, will
automatically fill out the the next cell with a name i.e.

I select No. 120 and the next cell automatically fills out the name as
being
Angela9520. How can I do that? Ostensible I want to select a number and
have the name associated with that number appear in the next cell!

I tried that and it works find with the first number on the drop down list
but I can't seem to extend the formula so that the second number, if
selected, shows me the second name. This is assuming I am only using A1 to
select the number. I can use A2 and modify the formula but that isn't the
idea of a drop down list. Or perhaps my limited experience is preventing me
from seeing!

"L. Howard Kittle" wrote:

I don't have 2007 but I think you can use VLOOKUP.

Something like this in B1 =VLOOKUP(A1,J1:K1,2,0)

Where A1 is the drop down and B1 has the formula and J is a list of the
numbers in the drop down and K is the corresponding names associated to that
number.

HTH
Regards,
Howard

"Angela9520" wrote in message
...
I would like to create a drop down list of number that, when selected, will
automatically fill out the the next cell with a name i.e.

I select No. 120 and the next cell automatically fills out the name as
being
Angela9520. How can I do that? Ostensible I want to select a number and
have the name associated with that number appear in the next cell!


.

Send me an example workbook and I will give it a go. Include what you want
to happen and where.


Regards,
Howard

"Angela9520" wrote in message
...
I would like to create a drop down list of number that, when selected, will
automatically fill out the the next cell with a name i.e.

I select No. 120 and the next cell automatically fills out the name as
being
Angela9520. How can I do that? Ostensible I want to select a number and
have the name associated with that number appear in the next cell!

Howard gave you a one row lookup table range. You must extend that range.

=VLOOKUP(A1,$J$1:$K$20,2.FALSE) entered in B1

Assumes dropdown in A1 and a list of numbers in J1:J20 and list of names in
K1:K20


Gord Dibben MS Excel MVP


On Thu, 4 Feb 2010 21:19:01 -0800, Angela9520
wrote:

I tried that and it works find with the first number on the drop down list
but I can't seem to extend the formula so that the second number, if
selected, shows me the second name. This is assuming I am only using A1 to
select the number. I can use A2 and modify the formula but that isn't the
idea of a drop down list. Or perhaps my limited experience is preventing me
from seeing!

"L. Howard Kittle" wrote:

I don't have 2007 but I think you can use VLOOKUP.

Something like this in B1 =VLOOKUP(A1,J1:K1,2,0)

Where A1 is the drop down and B1 has the formula and J is a list of the
numbers in the drop down and K is the corresponding names associated to that
number.

HTH
Regards,
Howard

"Angela9520" wrote in message
...
I would like to create a drop down list of number that, when selected, will
automatically fill out the the next cell with a name i.e.

I select No. 120 and the next cell automatically fills out the name as
being
Angela9520. How can I do that? Ostensible I want to select a number and
have the name associated with that number appear in the next cell!


.

Hi Gord,

Well that makes sense, I was not wrapping my head around what the OP was
shooting at.

H

"Gord Dibben" gorddibbATshawDOTca wrote in message
...
Howard gave you a one row lookup table range. You must extend that range.

=VLOOKUP(A1,$J$1:$K$20,2.FALSE) entered in B1

Assumes dropdown in A1 and a list of numbers in J1:J20 and list of names
in
K1:K20


Gord Dibben MS Excel MVP


On Thu, 4 Feb 2010 21:19:01 -0800, Angela9520
wrote:

I tried that and it works find with the first number on the drop down list
but I can't seem to extend the formula so that the second number, if
selected, shows me the second name. This is assuming I am only using A1
to
select the number. I can use A2 and modify the formula but that isn't the
idea of a drop down list. Or perhaps my limited experience is preventing
me
from seeing!

"L. Howard Kittle" wrote:

I don't have 2007 but I think you can use VLOOKUP.

Something like this in B1 =VLOOKUP(A1,J1:K1,2,0)

Where A1 is the drop down and B1 has the formula and J is a list of the
numbers in the drop down and K is the corresponding names associated to
that
number.

HTH
Regards,
Howard

"Angela9520" wrote in message
...
I would like to create a drop down list of number that, when selected,
will
automatically fill out the the next cell with a name i.e.

I select No. 120 and the next cell automatically fills out the name as
being
Angela9520. How can I do that? Ostensible I want to select a number
and
have the name associated with that number appear in the next cell!


.

I thought it was just a typo and you meant J1:K10g


Gord

On Fri, 5 Feb 2010 10:59:05 -0800, "L. Howard Kittle"
wrote:

Hi Gord,

Well that makes sense, I was not wrapping my head around what the OP was
shooting at.

H

"Gord Dibben" gorddibbATshawDOTca wrote in message
.. .
Howard gave you a one row lookup table range. You must extend that range.

=VLOOKUP(A1,$J$1:$K$20,2.FALSE) entered in B1

Assumes dropdown in A1 and a list of numbers in J1:J20 and list of names
in
K1:K20


Gord Dibben MS Excel MVP


On Thu, 4 Feb 2010 21:19:01 -0800, Angela9520
wrote:

I tried that and it works find with the first number on the drop down list
but I can't seem to extend the formula so that the second number, if
selected, shows me the second name. This is assuming I am only using A1
to
select the number. I can use A2 and modify the formula but that isn't the
idea of a drop down list. Or perhaps my limited experience is preventing
me
from seeing!

"L. Howard Kittle" wrote:

I don't have 2007 but I think you can use VLOOKUP.

Something like this in B1 =VLOOKUP(A1,J1:K1,2,0)

Where A1 is the drop down and B1 has the formula and J is a list of the
numbers in the drop down and K is the corresponding names associated to
that
number.

HTH
Regards,
Howard

"Angela9520" wrote in message
...
I would like to create a drop down list of number that, when selected,
will
automatically fill out the the next cell with a name i.e.

I select No. 120 and the next cell automatically fills out the name as
being
Angela9520. How can I do that? Ostensible I want to select a number
and
have the name associated with that number appear in the next cell!


.