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