Drop down to select MULTIPLE rows

[prabhucse]

Hi,

I have a situation where, need to select 1 drop down list.
On selecting one, then it should populate 4 rows below.

A
===
1-Collection
2-Input File Naming
3-Duplicate File Checking

B
===
4-Post-Collection Action
5-Input File Format
6-Pre-Collection Action

If i select A from the drop down, all the 3 rows namely:-
1-Collection
2-Input File Naming
3-Post Collection Action

should be inserted as per the above.

VLOOKUP is adding columns, but i need to inserts rows here.

Thanks before for your reply.

[Glenn Kennedy]

Assuming your DD is in A1 and a table of responses is in D3 to D8, use this

=INDEX($E$3:$E$8,MATCH($A$1,$D$3:$D$8,0)) for the first answer,
=INDEX($E$3:$E$8,MATCH($A$1,$D$3:$D$8,0)+1) for the second and
=INDEX($E$3:$E$8,MATCH($A$1,$D$3:$D$8,0)+2) for the third.