Help with IF THEN FUNCTION

example.xlsxHey, 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.

I am just guessing what I need, but haven't had so much luck yet.
Here is what I have placed in excel, but it doesn't work.

=IF(D17=Target Change - Report,[Target Change: ],[Current Target:]

What I want to do. I have a dropdown menu (cell D17) that you can choose the subject line for the email & I want this formula to be conditional based on the subject line to change either to Target Change or Current Target if the subject line doesn't have target change - report/update selected. If it is a target change I want the cell to say target change, but if not I want it to say Current Target.

=IF D17=Target Change - Report OR Target Change - Update, Target Change:, Current Target:

Let me know what you think & I greatly appreciate it!

Tyriel, welcome to the forum.

Perhaps you could upload a small sample workbook, showing your expected outcome, as it isn't clear, at least to me, if you mean IF D17 = (a value assigned to "target change") MINUS (a value assigned to ""report"), or if you mean IF D17 contains the text "Target Change - Report",... which seems unlikely, but the less guessing we have to do, the quicker you'll be helped

I'm a bit unsure too as to what you require exactly but it looks like you have a drop down (D17) with several subject lines. Then depending on the subject you want cell X to display something (you refer to as Target Change OR Current Target.

If the drop down list is written on the sheet (or another sheet) you may want to put in the next column next to each option the value you want to show and perform a lookup so you correctly display the required output.


As BB1972 as mentioned a sample file will further help explain what you require, to upload a file click Go Advanced under the bit where you write a new post. Then click Manage Attachments and you can add a file from there.

Firstly apologies for overlooking the attached file, didn't see it hiding there.

I have attached an amended copy of this for you which uses the vlookup method to show the reult you want for each Subject Line.
If you want to use the IF method to show the correct result then try:

=IF(OR(G4=A,G4=B),"SHOW THIS",IF(OR(G4=C,G4=D),"SHOW THIS","ELSE SHOW THIS"))
where G4 is the drop down cell and A B C and D are the cells in Col D. Its along the same route you had originally but with a second IF function nested inside the first to test for the next bit. Hope that made sense anyway.

I've put forward the vlookup solution instead as the best way to do this, should you want to change what is displayed for a certain subject line you simply change the corresponding value in column E which saves you picking through your formulas again.