Excel 2010 assistance.
I am a novice at Formulas in Excel so I am looking for some help. I have a new hire form that I have created that fills in all the other forms I need to fill out depending on a person’s function and the department they work for inside the company. I am stuck on filling out an email address, rather choosing the correct @xyz.com address based on another selection.
On sheet 1 D9 I have a drop down list (from F20-F23) that has 4 possible entries. 3 of the 4 all have @xyz.com address; the 4th will have a @abc.com address. The attached is a copy of the form. If the user chooses in this case Fire the domain would be @abc.com.
C10 is where I am having an issue. I don’t know how to make this so that if on Sheet1!d9 = Fire to change xyz to abc