Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down box or list
I have been getting pretty good with excel but there are things that I just
do not understand. I have a cell that I enter a name. Some of the names are long and I would like to make the entry quicker. What is the best way? I think it is a drop down box but I just do not understand how to get started. Do I make a list? What? Help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down box or list
A drop down would work. Go to Data Validation Settings Allow List
Source Select the list of names OK. Or for the Source you can enter the names in the Source box separated by a coma (no space) or you can name the list you have on the worksheet someplace, say name it MyList and then in the source box enter =MyList. HTH Regards, Howard "Capt. Andy" <Capt. wrote in message ... I have been getting pretty good with excel but there are things that I just do not understand. I have a cell that I enter a name. Some of the names are long and I would like to make the entry quicker. What is the best way? I think it is a drop down box but I just do not understand how to get started. Do I make a list? What? Help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down box or list
Use Excel's buit-in Data Validation dropdown list.
Find the how-to's here. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben MS Excel MVP On Mon, 16 Mar 2009 14:43:03 -0700, Capt. Andy <Capt. wrote: I have been getting pretty good with excel but there are things that I just do not understand. I have a cell that I enter a name. Some of the names are long and I would like to make the entry quicker. What is the best way? I think it is a drop down box but I just do not understand how to get started. Do I make a list? What? Help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down box or list
OK! I have my drop-down list working. Now, each name in the drop-down box
(these are boats) has a specific number attached to it (official vessel number). I would like for that number to pop up in another cell when the name of the vessel is entered. I tried insertname but am unable to make it work as yet. "Capt. Andy" wrote: I have been getting pretty good with excel but there are things that I just do not understand. I have a cell that I enter a name. Some of the names are long and I would like to make the entry quicker. What is the best way? I think it is a drop down box but I just do not understand how to get started. Do I make a list? What? Help! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down box or list
Hey Skipper...Capt.
Looks like you need to do a Vlookup and a list of the boat names in one column and the boat number in the next column. Your vlookup formula would look something like this... =VLOOKUP(A1,F1:G20,2,0) Where A1 is where you have the dropdown Where column F is the list of the names of the boats Where column G is the list of the respective boat numbers HTH Regards, Howard "Capt. Andy" <Capt. wrote in message ... I have been getting pretty good with excel but there are things that I just do not understand. I have a cell that I enter a name. Some of the names are long and I would like to make the entry quicker. What is the best way? I think it is a drop down box but I just do not understand how to get started. Do I make a list? What? Help! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down box or list
Thanks, Howard,
Now I need to be able to attach a number associated with the name in the drop-down in another cell. I have been studying hard and I am thinking the VLOOKUP function might be the way to go. In other words the name in the drop-down is "M/V North Wind" and her offical number is "123456". North Wind was in the drop-down and in the ajacent cell her official number would pop up. I have hundreds of boats that I am dealing with. I realize that I could just add the number to the name when I enter the name for the drop-down but it is not as clean looking. And not nearly as cool. Thanks for your help, Capt. Andy "L. Howard Kittle" wrote: A drop down would work. Go to Data Validation Settings Allow List Source Select the list of names OK. Or for the Source you can enter the names in the Source box separated by a coma (no space) or you can name the list you have on the worksheet someplace, say name it MyList and then in the source box enter =MyList. HTH Regards, Howard "Capt. Andy" <Capt. wrote in message ... I have been getting pretty good with excel but there are things that I just do not understand. I have a cell that I enter a name. Some of the names are long and I would like to make the entry quicker. What is the best way? I think it is a drop down box but I just do not understand how to get started. Do I make a list? What? Help! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down box or list
Howard,
It is all working. I thank you very much. I probably woul have taken me forever to get the formula correct. Now all I have to do is do an 'If' stament to get rid of the #N/A. Also in all my looking around I thought I saw somthing about about getting to the name in the drop-down quicker. At this time I have 158 names and it is still growing. That is lotsa scrolling. Again, Thanks Capt. Andy "L. Howard Kittle" wrote: Hey Skipper...Capt. Looks like you need to do a Vlookup and a list of the boat names in one column and the boat number in the next column. Your vlookup formula would look something like this... =VLOOKUP(A1,F1:G20,2,0) Where A1 is where you have the dropdown Where column F is the list of the names of the boats Where column G is the list of the respective boat numbers HTH Regards, Howard "Capt. Andy" <Capt. wrote in message ... I have been getting pretty good with excel but there are things that I just do not understand. I have a cell that I enter a name. Some of the names are long and I would like to make the entry quicker. What is the best way? I think it is a drop down box but I just do not understand how to get started. Do I make a list? What? Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |