Substitute function

[daniiviana]

Hello All,

I'm trying to get one text to be replaced by another, but I bump in several issues. The text are several sentences, and each couple sentences can be substitute for one other sentence:

In one cell, a user can choose the best option amount 16. Examples of the options are: "urgent issue", "SLA breach", "Excessive email correspondence". In another cell I am trying to get these options "translated" into another sentence, for better understand. So for example. Every time that the user choose "SLA breach" in cell B2, the sentence will be translated into "Communication issues (SLA lost or repetitive emails)". The same happens if the user input "Excessive email correspondence" in cell B2.

Screen Shot 2020-05-05 at 20.16.41.png

I don't know if this is even possible to do it, but someone can help me? Sorry I was not able to attach an example file, but I did my best trying to explain this

[FDibbins]

Sounds to me like you need to create a reference table that will contain the options from col A, and a "translation" in the next column. You could then use a simple vlookup to return the required translation

[FAT JPM]

Hello daniiviana,

Just like FDibbins said before, you have to create one table to make iist of reason and their respective translation.
And then use vlookup formula to return the translation value.
Maybe you could look at my excel file for more detail.

[daniiviana]

This is perfect! Thank you!