Try something like this:
A1: (a source string, like 2B75478A3)
This formula looks up the 2nd char from that string in the table at B2:G20
and returns the corresponding value from Col_G
OR...if you want error checking
Is that something you can work with?