Reference Mapping

[SH_94]

Dear Community,

I would like to ask how can we create the formula as below

1. If the number start with 1 , the result will be AA

2. If the number start with 7. the result will be  CF

3. If the number start with 5, the result will be KI

4. If the number start with 6, the result will be UE

Many thanks for the help.

[atcodedog05]

Hi @SH_94 

The best dynamic option is to use find and replace tool so that you can add more to the list.

Hope this helps : )

[JaeLim · Accepted solution]

Hi  @SH_94 ,

This can easily be done using the formula tool as shown below:

Hope this helps!