| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I fill mutiple cells with one pull down menu?
I am trying to auto add a site address by selecting the site name from a drop
down menu. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I fill mutiple cells with one pull down menu?
You could use either a VLOOKUP or INDEX/MATCH in each of the multiple cells
to lookup that DV cell, and extract the relevant col's info from the source table housing the site name, address and other fields Browse Debra's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "garr1095" wrote: I am trying to auto add a site address by selecting the site name from a drop down menu. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank Rows from Merged Cells in Drop Down Menu | Excel Discussion (Misc queries) | |||
| Sum cells by fill colour | Excel Discussion (Misc queries) | |||
| FILL IN BLANK CELLS | Excel Discussion (Misc queries) | |||
| What is a Conditional pull down menu? | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Linear Mode
