Including text from another cell in a formula

I have the following formula in a cell

=IF(AND(D17="X",F17="",H17="",J17="",L17=""),"Who is the "&E17&" of "&Q8&" and we are valuing ",IF(AND(D17="",F17="X",H17="",J17="",L17=""),"Who is a "&G17&" in "&Q8&" and we are valuing ",IF(AND(D17="",F17="",H17="X",J17="",L17=""),"Who is a "&I17&" in "&Q8&" and we are valuing ",IF(AND(D17="",F17="",H17="",J17="X",L17=""),"Who is an "&K17&" of "&Q8&" and we are valuing ",IF(AND(D17="",F17="",H17="",J17="",L17="X"),"Who is a "&M17&" of "&Q8&" and we are valuing","")))))

and I want to add the text contents of cell AA18 after each phrase ...we are valuing.... I have included the worksheet. Thanks in advance. (For those of you who are following my progress, the tumor has shrunk by 50% and we are only 25% through the Proton Therapy. They are carving this thing up like a Christmas turkey! Chemo is hell but I still have my hair.)
EE-Snippet-CalcXLM-Report-Rev-25H-T.xlsm
LVL 1
Bill GoldenExecutive Managing MemberAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

regmigrantCommented:
How about a simple search and replace? (extreme right of Home tab)

Find: valuing"
replace with: valuing" & aa18

Options:  formulas
Rgonzo1971Commented:
Hi,

pls try

=IF(AND(D17="X",F17="",H17="",J17="",L17=""),"Who is the "&E17&" of "&Q8&" and we are valuing ",IF(AND(D17="",F17="X",H17="",J17="",L17=""),"Who is a "&G17&" in "&Q8&" and we are valuing ",IF(AND(D17="",F17="",H17="X",J17="",L17=""),"Who is a "&I17&" in "&Q8&" and we are valuing ",IF(AND(D17="",F17="",H17="",J17="X",L17=""),"Who is an "&K17&" of "&Q8&" and we are valuing ",IF(AND(D17="",F17="",H17="",J17="",L17="X"),"Who is a "&M17&" of "&Q8&" and we are valuing"&" "&AA18,"")))))

Open in new window

Regards
Professor JMicrosoft Excel ExpertCommented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bill GoldenExecutive Managing MemberAuthor Commented:
regmigrant, I could not get your formula to save and Rgonzo1971 your solution returned a strange 0 centered on the bottom line.  Professor I had to add the syntax on the last selection but it worked perfectly.  Thanks
Professor JMicrosoft Excel ExpertCommented:
you are welcome. i am glad it worked.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.