B2=IFERROR(VLOOKUP(RIGHT(A2,1),$D$
2:$E$
5,2,0),"")&IFERROR(VLOOKUP(MID(A2,2,1),$D$
2:$E$
5,2,0),"")&IFERROR(VLOOKUP(MID(A2,3,1),$D$
2:$E$
5,2,0),"")&IFERROR(VLOOKUP(MID(A2,4,1),$D$
2:$E$
5,2,0),"")&IFERROR(VLOOKUP(LEFT(A2,1),$D$
2:$E$
5,2,0),"")