hi
I have spent several months comiling a construction risk assessment in excel format. to date i have created a list of hazards on sheet two and included these in a drop down list in sheet one. I now wish to create a list of control measures in sheet 2 which correspond with each hazard in the list on sheet one and the control measure displayed in a specific cell in sheet one. Is this possible if so can anyone assist. ( i will add that up until i began this project i knew nothing at all about excel so if possible can you provide an idiot proof answer).
Thanks in advance any assistance will be greatly appreciated.