IF, IFERROR, SEARCH nested formula help
Hi team -
Looking for help in either fixing the below formula or creating a new formula.
Goal behind the logic:
Be able to use this cell to confirm if another column,same row (Level) has the abbreviation "Mgr."
If it doesn't add a dash "-", full stop.
If it does, we need to search another column,same row (rep region) for the letters "AE", "RM", or "RS".
- If the string has "RM" show "RM" in this cell.
- If the string has "AE" show "AE" in this cell
- Or If the string has "RS" show "RM" in this cell (yes, change to RM)
Chart: Blue columns is the data, orange column is where the formula will live.
Syntax: (Coming up as #unparseable)
=IF([Level]@row="Mgr",IFERROR(IF(SEARCH("RM",[Rep Region]@row,1),"RM"),IFERROR(IF(SEARCH("AE",[Rep Region]@row,1),"AE"),IF(SEARCH("RS",[Rep Region]@row,1),"RM"))),"-")
Help Article Resources
Check out the Formula Handbook template!