Populating multiple cells from a single pull down

[ckramer7070]

I need to pull values from multiple cells in a single row and place
them into another worksheet in specified cells. I have setup a pull
down in Worksheet2 to show all of the values in a column on Worksheet1.
When I select one of these values in the pull down I need to grab 6
other cells in Worksheet1 (from the same row) and place them into
Worksheet2 in different rows/columns.
Is this possible, and do I need to use a macro to accomplish this?

I appreciate any help.

Thanks,

Chad

 

[Bernie Deitrick]

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,FALSE)
=VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,3,FALSE)
=VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,4,FALSE)
=VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,5,FALSE)
=VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,6,FALSE)
=VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,7,FALSE)

HTH,
Bernie
MS Excel MVP

 

[ckramer7070]

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,FALSE)
=VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,3,FALSE)
=VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,4,FALSE)
=VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,5,FALSE)
=VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,6,FALSE)
=VLOOKUP(Worksheet2!A1,Worksheet1!$A$1:$G$100,7,FALSE)

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/Pub0009/LPMArticle.asp?ID=446

Thanks again,

Chad