I have a sheet containing work tasks and associated hazards:
<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!!
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!!