HI,

I have a (currently) two worksheet workbook set up

On sheet 1, I have data from row 2:row 25 including values in cells C2:C:25 similar to this: C330698-9

On Sheet 2, I have a table which:
Has a Horizontal axis from cells B3:L3 contains the values 0 thru A {Hex}
Has a Vertical axis from cells A4:A24 contains the values 0 thru 20{Dec}
Contains Text data in the cells B4:L24


I am trying to create a formula which will be placed in cells Sheet 1!J2:J25
The intent of the formula is to use the INDEX and MATCH functions to
Pull the 5th value and the 10th value from the values in cells C2:C:25 using the RIGHT and MID functions
Use those two values to cross reference the table on sheet 2
Present the values recovered from the table in cells Sheet 1!J2:J25

Here is the formula I have in cell J2 now
=INDEX(Table3,MATCH((RIGHT(C2,1)),Sheet2!A4:A24,0),MATCH((MID(C2,5,1)),Sheet2!B3:L3,0))

But all I get in the cell is: #N/A

What am I doing wrong?
Thanks in advance!

Marc