Not sure if this is what you are looking for but give it a try and see. I'm assuming you are still wanting to use D,E,F,G,H as your Cell input. This formula would allow you to enter more than the single letter. For example you could enter Da1-2 in C2 and the formula will still display correctly.
Do keep in mind your Cell input has to begin with your base input letters D,E,F,G,H
Code:
=IF(LEFT(C2,1)="D","Account Requiring Assist Code Adjustment",IF(LEFT(C2,1)="E","Adjust Source Code",IF(LEFT(C2,1)="F","Adjust LM Counselor",IF(LEFT(C2,1)="G","Adjust Plan Type",IF(LEFT(C2,1)="H","Email Assigned Host or Negotiator","")))))
Bookmarks