If or 3 options help

Hey, guys. I am trying to do some formatting for a template and I need a piece of the message I generate with the formula to be conditional on another cell.

What I have now...

I have a dropdown menu (cell D17) that you can choose the subject line for the email & I want this formula (below) to be conditional based on the subject line. Right now, when I change the dropdown (subject line) to target change report/update, the formula will display Target Change, but if it doesn't say target change report/update then it will say Current Target: .

=IF(OR(D17=D4,D17=D5), "Target Change: ", "Current Target: ")

What I want to add to the former formula or make this happen somehow.

In the dropdown menu there is an option for a target suggestion & I want the formula to have a third option that will say if target suggestion is selected as well then the formula will automatically say," Target Suggestion: ".

I know that this is possible because I have done similar functions, but I think I may be having a brain fart. Let me know what you think & I greatly appreciate it!

Hi Ron,

That worked great! Thanks for your help!