|
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
|