Hello, I would like to write a macro to return values in adjacent cell if a cell contains certain text. For example, if D2 contains any of the following, write the corresponding value in E2; same for D3, D4, etc.:
If D2 contains "REG_EU", write Europe in E2 and/or
If D2 contains "CN", write...