Forum Discussion
Using a named range in an "IF" statement
A couple of thoughts here.
First, it always helps the helpers on this forum if those of you with questions can post a copy (without personal or confidential info) of the spreadsheet in question.
Second, in the absence of such a sample file, given the subject matter, I think you might be well served by looking to accomplish your "If...Then..." conditional in Word itself, rather than in Excel. You can search the help text for Word using a phrase like "Conditional Mail Merge" and get some step by step examples. [I did this recently, so know it works.]
It's been literally a couple of decades since I did something comparable in my job, and that was for around a thousand employees. It's a challenge, but really fun when you make it work.
Come back with a sample of your file(s) if you still need further help. But DO check out Word's abilities to do conditional merges in conjunction with Excel as the data source.