Hi Guys, happy new year.

Just wanted to ask help. I wanted to get the value on the 2nd column if i will encode the code on the first column. please refer to the table below. Thanks a lot.

1st column 2nd column
ME or S 50,000.00
ME1 or S1 75,000.00
ME2 or S2 100,000.00
ME3 or S3 125,000.00
ME4 or S4 150,000.00