Vlookup with multiple cells

[WBlenner]

I have a sheet containing work tasks and associated hazards:

Task1	Hazard 1	Control 1
	Hazard 2	Control 2
	Hazard 3	Control 3
Task 2	Hazard 4	Control 4
	Hazard 5	Control 5

<TBODY>
</TBODY>

For each task there may be up to 6 separate hazards.

In a new sheet i want to select the Task from a drop-down menu in A1 then using Vlookup, populate B1:B3 with corresponding Hazards, C1:C3 with corresponding controls etc.


I am a novice, i have a little bit of experience with Vlookup, but i wonder if MATCH or INDEX would be better suited?

Any help appreciated!!

 

[mfexcel]

I think what you need is to create a dynamic drop down list with Data Validation
The following site contain very good tutorials about the topic
http://www.contextures.com/excel-data-validation-multiple.html#more

 

[Aladin Akyurek]

Can you change the lay-out as shown below:

Task1	Hazard 1	Control 1
Task1	Hazard 2	Control 2
Task1	Hazard 3	Control 3
Task2	Hazard 4	Control 4
Task2	Hazard 5	Control 5

<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3640" width=102><COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 3271" width=92><TBODY>
</TBODY>