Using Mail Merge to Write a Proposal?

[knuckledownlacrosse]

Good Morning!

I have two questions for you all this morning. First, I am using Excel and a Mail Merge Template in Word to write proposals for my company. My main question, is that I would like to write this formula for G2: If I2 matches the test is Sheet 2, Column A, the put the text in sheet 2, column B in G2.

The other question that I have: Is this the most efficient way to go about this or is there a better way to turn a Needs Assessment into a Proposal?

Thanks!

[dflak]

I'm assuming you want to match F2. This formula should do it: =IF(ISNUMBER(MATCH(F2,'Description of Events'!A:A,0)),'Description of Events'!B2,"")

Match finds the row number for the first occurrence of F2 in column A on the second sheet if it exists. Otherwise it returns #N/A. Is number tests for this condition and returns true if the value is actually found.