Hi
i am not really competent in excel i have spent several months designing a construction risk assessment form. So far I have created a list of hazards in sheet 2 then created a drop down list incorporating these in sheet one, i now want to automatically display control measures in another cell in sheet one which corresponds to the hazard chosen from the drop down list. Is this possible and if so can anybody offer assistance. Any assistance would be very much appreciated.

Thank for taking the time to read my post.

Robert