Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Question
Hi,
I want to create a Drop Down menu in Excel. After I create the Drop Down menu, and when I select a name from the drop down menu, the name selected should populate or display the address information of that name in the other columns i.e. 1 column for city, 1 country, 1 for postal code/zip, etc. How do I go about doing that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Question
check it here
http://www.contextures.com/xlDataVal02.html On Oct 17, 4:47*am, neostar77 wrote: Hi, I want to create a Drop Down menu in Excel. After I create the Drop Down menu, and when I select a name from the drop down menu, the name selected should populate or display the address information of that name in the other columns i.e. 1 column for city, 1 country, 1 for postal code/zip, etc. How do I go about doing that? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Question
You can use VLookup formulas to display the related data. There's an
example in an order form he http://www.contextures.com/xlOrderForm01.html And instructions for VLookup formulas he http://www.contextures.com/xlFunctions02.html neostar77 wrote: Hi, I want to create a Drop Down menu in Excel. After I create the Drop Down menu, and when I select a name from the drop down menu, the name selected should populate or display the address information of that name in the other columns i.e. 1 column for city, 1 country, 1 for postal code/zip, etc. How do I go about doing that? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Question
Hi,
I have an answer for this question. Once you select the city from the drop down list - for say cell - A1, ensure the info should capture another cell for say - C1.if you use an IF formula as below. =if(C1="London",Address Details,if(C1="New Yrok"),Address Details)) Please let me know if you are not clear with this. Regards, "Debra Dalgleish" wrote: You can use VLookup formulas to display the related data. There's an example in an order form he http://www.contextures.com/xlOrderForm01.html And instructions for VLookup formulas he http://www.contextures.com/xlFunctions02.html neostar77 wrote: Hi, I want to create a Drop Down menu in Excel. After I create the Drop Down menu, and when I select a name from the drop down menu, the name selected should populate or display the address information of that name in the other columns i.e. 1 column for city, 1 country, 1 for postal code/zip, etc. How do I go about doing that? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list question | Excel Discussion (Misc queries) | |||
Question on using a Drop Down Menu. | Excel Discussion (Misc queries) | |||
Drop Down List Question | Excel Discussion (Misc queries) | |||
Drop Down List Question | Excel Discussion (Misc queries) | |||
drop down list question | Excel Discussion (Misc queries) |