How do I set up a text formula?
 

I have a report with 30 different options and I'd like to set up a formula
where for each option there is corresponding text.. How can I make this
happen? The options I have set-up are in cells a-e15 through a-e21. For
example a15 reads: Excavation. When it is chosen to be put down below into
the template, I would like to have a corresponding response to it. ie:
Excavation is.......

How do I set up a text formula?
 

Use a VLOOKUP table.

In A1 thru B19 put:

hat to put on your head
cat to eat mice
bat to fly at night
mat to step upon
flat to avoid bumps
nat to buzz overhead
rat to eat the cheese
pat to sooth the cat
fat to eat too much

in D5 put:
flat
in E5 put:
=VLOOKUP(D5,A1:B9,2)
to display the corresponding phrase
--
Gary''s Student - gsnu200730


"JJacobs" wrote:

I have a report with 30 different options and I'd like to set up a formula
where for each option there is corresponding text.. How can I make this
happen? The options I have set-up are in cells a-e15 through a-e21. For
example a15 reads: Excavation. When it is chosen to be put down below into
the template, I would like to have a corresponding response to it. ie:
Excavation is.......

How do I set up a text formula?
 

Is this possible without showing the corresponding text on the same page? I
am very new to this, is there any way you can explain to me how to do this
step by step. Thankyou!

"Gary''s Student" wrote:

Use a VLOOKUP table.

In A1 thru B19 put:

hat to put on your head
cat to eat mice
bat to fly at night
mat to step upon
flat to avoid bumps
nat to buzz overhead
rat to eat the cheese
pat to sooth the cat
fat to eat too much

in D5 put:
flat
in E5 put:
=VLOOKUP(D5,A1:B9,2)
to display the corresponding phrase
--
Gary''s Student - gsnu200730


"JJacobs" wrote:

I have a report with 30 different options and I'd like to set up a formula
where for each option there is corresponding text.. How can I make this
happen? The options I have set-up are in cells a-e15 through a-e21. For
example a15 reads: Excavation. When it is chosen to be put down below into
the template, I would like to have a corresponding response to it. ie:
Excavation is.......

How do I set up a text formula?
 

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!!


"JJacobs" wrote:

Is this possible without showing the corresponding text on the same page? I
am very new to this, is there any way you can explain to me how to do this
step by step. Thankyou!

"Gary''s Student" wrote:

Use a VLOOKUP table.

In A1 thru B19 put:

hat to put on your head
cat to eat mice
bat to fly at night
mat to step upon
flat to avoid bumps
nat to buzz overhead
rat to eat the cheese
pat to sooth the cat
fat to eat too much

in D5 put:
flat
in E5 put:
=VLOOKUP(D5,A1:B9,2)
to display the corresponding phrase
--
Gary''s Student - gsnu200730


"JJacobs" wrote:

I have a report with 30 different options and I'd like to set up a formula
where for each option there is corresponding text.. How can I make this
happen? The options I have set-up are in cells a-e15 through a-e21. For
example a15 reads: Excavation. When it is chosen to be put down below into
the template, I would like to have a corresponding response to it. ie:
Excavation is.......