| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down menus
Is there any way in Excel 2003 that I can click a name on a drop down list
and get other information to come up in other cells? ie if I click a client name in a drop down list can I get their address information to come up in another cell on the same worksheet? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down menus
Yes. You'll need to setup a table, but take a look in XL help file at the
LOOKUP and VLOOKUP functions. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Emerald1170" wrote: Is there any way in Excel 2003 that I can click a name on a drop down list and get other information to come up in other cells? ie if I click a client name in a drop down list can I get their address information to come up in another cell on the same worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down Menus | Excel Worksheet Functions | |||
| Drop-Down Menus | Excel Discussion (Misc queries) | |||
| Drop down menus | Excel Worksheet Functions | |||
| drop down menus | Excel Discussion (Misc queries) | |||
| Drop down menus | Excel Discussion (Misc queries) | |||
Linear Mode
