I tried the vlookup and it did not work for me. Let me show you what I have
and what i need to do:
POTENTIAL HAZARDS:
A15: Electrocution/Shock B15: Hot Surfaces C15: Excavation D15:
Chemicals E15: Repetitive Motion
A16: Fall From Heights B16: Pinch Points C16: Confined Space D16:
Asbestos/Lead/Silica E16: Welding Arc
A17: Elevated/Overhead Work B17: Flying Particles C17: Line Break D17: Poor
Lighting E17: Noise
A18: Manual Lifting B18: Vehicle Traffic C18: Poor Work Position D18:
Environment: Heat/Cold E18: Flammable Materials
A19: Rough/Sharp Material B19: Animal, Vermin, Snake, Insect C19:
Housekeeping D19: Compressed Air E19: Machinery-Rotate/Moving
A20: Slippery/Uneven Surfaces B20: Toxic Atmosphere C20: Other D20: Struck
By, Caught In/On/Between E20: Laceration/Puncture
Identified Potential Hazard(s): Detailed Sequence Of Job Steps:
Section(s):
=E18 Flammable Mat'l. **(Always have fire extinguisher)
=C19 Housekeeping **(Always keep work area clean)
I have all the these things in 5 columns and 6 rows, everything is labeled
in which column and row it is in.. Im sure there is an easier way, but i am
unaware of it.. Anyway under the "Identified Potential Hazard" when I put
(=A18 Flammable Mat'l) I also want the "Detailed Sequence of Job Steps" to be
inserted (..Always have fire extinguisher..) i want the **(fire extinguisher)
text to pop up right when the =E18 Flammable Mat'l. is inserted. I have to do
this for 30 different things... Please help me!!