Using IF Search Function in Mail Merge

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hello sandy666

Thank you for your response, I have added a couple of files as you request, one is the data source and the other the merge template.
The merge template contains the "merge Field" "FieldA" - the data is what will populate or trigger the "smart fields", (as you can see there are 3 sheets within the data file providing the 3 options).

the first one (Sheet Option 1) is straight forward, the smart field would add the merge (hidden text) "yes we can do this for you"

If the data was sent with sheet option 2 as the response the smart field would be populated with the hidden merge text "yes we can do that for you"

the third sheet option 3 would trigger anything at the moment (which is my problem); what i want it to do is show both hidden text sentences, as shown in the third answer.

My thought is that instead of using the IF function with "= "Equal to" (as used in options 1 and 2) to use a function which I haven't used before which I think is called either "SEARCH" or "ISNUMBER" and use it in all three examples

So instead of using "Answer_1" or "Answer_"" we would be saying if it contain "1" anywhere or in option 2 "2" anywhere and then we could have the third option of 1 2 so it would trigger both hidden fields to show as the data contains both 1 & 2

Thank you for your help again, I am sorry I am not able to perhaps explain it better.

Thank you

I think you mixed two things: Word and Excel
Pay attention on Excel, what you want to do there, show BEFORE and AFTER so we can see what you want to achieve (in Excel)

If you want Excel reaction on something what will happen in Word you will need VBA and not on this forum (probably)

I read post #1 and #3 few times and honestly I don't understand what you want to do and how it should be working

Maybe someone else will understand better and will give you solution.