Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 drop down lists
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 drop down lists
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! . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 drop down lists
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 drop down lists
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! . |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 drop down lists
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! . |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 drop down lists
I thought it was just a typo and you meant J1:K10<g
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! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting drop down lists? (Excel 2007) | New Users to Excel | |||
Excel Drop Down Lists Help | Excel Worksheet Functions | |||
Excel Drop-down lists | Excel Discussion (Misc queries) | |||
Excel drop down lists | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |