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.

Mapping Refernce.xlsx

JaeLim

Hi  @SH_94 ,

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

Hope this helps! 

Reference Mapping.yxmd