Changing text in column A based on text in Column B

Hello Experts! I am trying to find a formula that will allow me to change text in one column based on text in another column. More specifically, we have had turnover of Admissions Counselors, and...

Charting

excel

Formulas and Functions

OliverScheurich
Sep 29, 2022
JordynMossFPU
=IF(NOT(ISNA(MATCH(B2&C2,$G$4:$G$7&$F$4:$F$7,0))),INDEX($H$4:$H$7,MATCH(B2&C2,$G$4:$G$7&$F$4:$F$7,0)),A2)
Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
In the example there is a table with new counselors initials for certain territories and cities in range F4:H7. If there is a new counselor the formula returns the initials in column D based on territory and city. If there isn't a new counselor the formula returns the initials of the counselor from column A.

OliverScheurich

Gold Contributor

Sep 29, 2022

JordynMossFPU

=IF(NOT(ISNA(MATCH(B2&C2,$G$4:$G$7&$F$4:$F$7,0))),INDEX($H$4:$H$7,MATCH(B2&C2,$G$4:$G$7&$F$4:$F$7,0)),A2)

Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.

In the example there is a table with new counselors initials for certain territories and cities in range F4:H7. If there is a new counselor the formula returns the initials in column D based on territory and city. If there isn't a new counselor the formula returns the initials of the counselor from column A.

JordynMossFPU
Copper Contributor
Sep 29, 2022
Thank you so much! I am going to try implementing this formula.
Thanks again!

Forum Discussion

Changing text in column A based on text in Column B

Resources