How do I set up a text formula?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JJacobs - 15 Jun 2007 21:44 GMT

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

Reply to this Message

Gary''s Student - 16 Jun 2007 01:22 GMT

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

Signature

Gary''s Student - gsnu200730

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

Reply to this Message

JJacobs - 19 Jun 2007 16:09 GMT

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!

> Use a VLOOKUP table.
>
[quoted text clipped - 22 lines]
> > the template, I would like to have a corresponding response to it. ie:
> > Excavation is.......

Reply to this Message

JJacobs - 20 Jun 2007 21:05 GMT

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

> 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
[quoted text clipped - 26 lines]
> > > the template, I would like to have a corresponding response to it. ie:
> > > Excavation is.......

Reply to this Message

Rate this thread: