Index Match to convert alphanumeric to pure numberic

[dj123171]

Hello, I am having a consistent #N/A error when I try to convert a Base36 alpha numeric string into a pure numeric string that represents where in the Base36 alphabet the digit represents. For example, for Base 36, the number 0 is 0, the letter F would represent 15 and W would represent 32. The alphabet is "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ" and I listed it in Column A, with numeric representations in Column B, represented here:

Column A	Column B
0	0
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
A	10
B	11
C	12
D	13
E	14
F	15
G	16
H	17
I	18
J	19
K	20
L	21
M	22
N	23
O	24
P	25
Q	26
R	27
S	28
T	29
U	30
V	31
W	32
X	33
Y	34
Z	35

<tbody>
</tbody>

If have C3 = W on the same sheet, I wanted to use the Index-Match to do the following:

D3=Index($A$1:$B$36,match(C3,$A$1:$A$36,0),2)

I am expecting the value of D3 = 32 but I get #N/A. Any suggestions here? Greatly appreciated!

 

[shg]

Those two functions are not compatible:

	A​	B​
2​	9​	A2: Input
3​	9	A3: =CHAR(A2+48+7*(A2>9))
4​	2​	A4: =CODE(A3)-48-7*ISTEXT(A3)

 

[Rick Rothstein]

Those two functions are not compatible:

	A​	B​
2​	9​	A2: Input
3​	9	A3: =CHAR(A2+48+7*(A2>9))
4​	2​	A4: =CODE(A3)-48-7*ISTEXT(A3)

I think the problem may have to do with real numbers versus text numbers. I think these two should work no matter which...

To go from a Decimal number (0 to 36) to Base36 "digit"...

=CHAR(A1+48+7*(--A1>9))

To go from Base36 "digit" to Decimal number...

=CODE(A1)-48-7*ISERR(--A1)