How to determine the value - 15 Dec?

[Eric]

Does anyone have any suggestions on how to determine the value within matrix?
There is a list of characters under following tables

This table is starting at cell B2 to N11

0A 0B 0C 0D 0E 0F 0G 0H 0I 0J 0K 0L
1G 1H 1I 1J 1K 1L 1A 1B 1C 1D 1E 1F
2E 2F 2G 2H 2I 2J 2K 2L 2A 2B 2C 2D
3K 3L 3A 3B 3C 3D 3E 3F 3G 3H 3I 3J
4C 4D 4E 4F 4G 4H 4I 4J 4K 4L 4A 4B
5H 5I 5J 5K 5L 5A 5B 5C 5D 5E 5F 5G
6L 6A 6B 6C 6D 6E 6F 6G 6H 6I 6J 6K
7A 7B 7C 7D 7E 7F 7G 7H 7I 7J 7K 7L
8D 8E 8F 8G 8H 8I 8J 8K 8L 8A 8B 8C
9J 9K 9L 9A 9B 9C 9D 9E 9F 9G 9H 9I

There is another list for value from B12 to N12
12 11 10 09 08 07 06 05 04 03 02 01

I would like to determine the value by inserting a number in cell A1, and
character in cell B1 and return the result in cell C1.
For example,
5 in cell A1 and F in cell B1, it should return 2 in cell C1
7 in cell A1 and A in cell B1, it should return 12 in cell C1
1 in cell A1 and H in cell B1, it should return 11 in cell C1

Does anyone have any suggestions on how to do it in excel?
Thanks in advance for any suggestions
Eric

 

[Rick Rothstein]

If I am not mistaken, I think you can delete that chart and use this formula
in its place...

=MOD(CHOOSE(A1+1,1,7,5,11,3,8,12,1,4,10)-(CODE(B1)-64)-1,12)+1

By the way, unless you left some data out, your columns go from B to M, not
B to N.

 

[Eric]

Thank everyone very much for suggestions
I try to re-word my description.
There is a list of characters under following tables

This table is starting at cell B2 to M11

AA AB AC AD AE AF AG AH AI AJ AK AL
BG BH BI BJ BK BL BA BB BC BD BE BF
CE CF CG CH CI CJ CK CL CA CB CC CD
DK DL DA DB DC DD DE DF DG DH DI DJ
EC ED EE EF EG EH EI EJ EK EL EA EB
FH FI FJ FK FL FA FB FC FD FE FF FG
GL GA GB GC GD GE GF GG GH GI GJ GK
HA HB HC HD HE HF HG HH HI HJ HK HL
ID IE IF IG IH II IJ IK IL IA IB IC
JJ JK JL JA JB JC JD JE JF JG JH JI

There is another list for value from B12 to M12
12 11 10 09 08 07 06 05 04 03 02 01

I would like to determine the value by matching a character in cell A1, and
character in cell B1 and return the result in cell C1 under row 12
For example,
B in cell A1 and F in cell B1, it should return 1 in cell C1
H in cell A1 and A in cell B1, it should return 12 in cell C1
E in cell A1 and H in cell B1, it should return 7 in cell C1

Does anyone have any suggestions on how to do it in excel?
Thanks in advance for any suggestions
Eric

 

[T. Valko]

Try this:

=SUMPRODUCT((B2:M11=A1&B1)*B12:M12)

 

[Rick Rothstein]

Try this array-entered** formula...

=14-MAX((A1&B1=$B$2:$M$11)*COLUMN($B$2:$M$11))

**Commit formula with Ctrl+Shift+Enter, not just Enter by itself.