Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel drop down menus
Alright so my question is how do you create a drop down list that once an
item is selected it will automatically fill in the rest of the information for you? For example Say in a drop down list you select a persons name. After I select their name i want their address to fill into the address area below. Anyone know how to do that????? Thanks! -- P |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel drop down menus
You would need to create a formula like a VLOOKUP that takes the selected
value and uses it in the VLOOKUP http://www.contextures.com/xlDataVal01.html http://www.contextures.com/xlFunctions02.html -- Regards, Peo Sjoblom "Paetra" wrote in message ... Alright so my question is how do you create a drop down list that once an item is selected it will automatically fill in the rest of the information for you? For example Say in a drop down list you select a persons name. After I select their name i want their address to fill into the address area below. Anyone know how to do that????? Thanks! -- P |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO YOU CREATE DROP DOWEN MENUS IN EXCEL? | Excel Worksheet Functions | |||
how do i set up drop down menus to populate cells in excel? | Excel Discussion (Misc queries) | |||
Creating Drop down menus in an excel cell | Excel Worksheet Functions | |||
how do I insert drop down menus into excel that are dependent on . | Excel Discussion (Misc queries) | |||
drop down menus in excel | Excel Discussion (Misc queries) |