Hello,
I am sure that this is possible and probably pretty easy for you guys, but looking for some assistance on this. I have a form (below) that has one drop down (Step 1.) and then the second (Step 2.) is dependent upon the selection in Step 1. Then the text input boxes below populate data from an excel file based on the selection in Step 2.
What I am looking to do is - whenever the middle box shows "Profile Update for Program Change" - I want to have a label populate the text "Program" in the header of that text input (highlighted). Whenever the box shows "Profile update for Concentration Change" - I want it to show "Concentration" instead.

I have two labels built off to the side, to see if there is a way to just have another label display one or the other, based off of what populates in the middle text box? Any ideas?? I was wondering if I could do a 'Ends with" formula, but not sure how to construct that...
@AJ_Z - this is sort of the same thing that you helped me with. Any thoughts?