We help IT Professionals succeed at work.
Get Started

Including text from another cell in a formula

Bill Golden
Bill Golden asked
Last Modified: 2016-02-26
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.)
Watch Question
Microsoft Excel Expert
Top Expert 2014
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE