I need a simple formula

[Guest]

I am trying to write a letter that could have one of several different
paragraphs. The paragraphs are too long to put in a drop-down box, so I need
some way of writing them into excel so that I can choose which one I want.
The other option is workbook A is a questionaire and worbook b is the
letter. Could I have the paragraph in workbook b chosen by the answer in
workbook A?

Thanks in advance

 

[Guest]

Hi,
One way is set up a table containing your paragraphs (as below):


Type Paragraph
1 This is the first paragraph ………
2 This is my second paragraph …..
3 …. And this my third …...


Assume the above, including headings, is in cells A1:B4

Then use VLOOKUP to get the required paragraph.

In the table above , the formula "=VLOOKUP(3,$A$2:$B$4,2) will get the
third paragraph.

Put the VLOOKUP formula in the appropriate cell(s) in your letter in
workbook or worksheet?) B.

Replace the "3" by the selection criteria from your questionnaire. These
criteria must be in the first column of the VLOOKUP table i.e replace my 1,2
and 3.

HTH