Referencing values in a static excel table with Access 2003

[siftedearth]

I have a field in an Access 2003 table (call it Field A that holds a value
between 1 and 24, and another field (Field B) that has a value between 1 -
100. I have a separate excel table filled with data that is (not
coincidentally) 24 rows long and 100 columns wide. I want to create a new
field (Field C) in access that cross references the values in Field A and
Field B to automatically set the value. So for example, Field A = 2 and
Field B = 4, and cell 2D in the excel table contains the value 18%, so Field
C is 18%.

Is there any way to do this, by somehow getting access to reference a static
table in excel?

If not, is there a way to import this data into access tables and perform
the operation in some other way?