| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populating multiple cells from a single pull down
Bernie Deitrick wrote: Chad, Use a set of VLOOKUP formulas (or INDEX/MATCH, depending on your layout) keyed to the value in your dropdown, to extract the data from your table. For example, if your value to match is in cell A1 on worksheet2, and would match values in the first column of worksheet1: =VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,2,FA LSE) =VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,3,FA LSE) =VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,4,FA LSE) =VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,5,FA LSE) =VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,6,FA LSE) =VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,7,FA LSE) HTH, Bernie MS Excel MVP Thanks Bernie, your suggestion worked perfectly. I have also found this article which steps the process out: http://pubs.logicalexpressions.com/P...cle.asp?ID=446 Thanks again, Chad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Cells Using Multiple Citeria | Excel Discussion (Misc queries) | |||
| Counting multiple values within single cells | Excel Worksheet Functions | |||
| make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
| Worksheet_Activate not working for multiple cells | Excel Discussion (Misc queries) | |||
| Pasting single cells from Word to multiple cells in Excel | Excel Worksheet Functions | |||
Hybrid Mode
