Though my problem is a bit more complicated than this, I think that if I
solve this, I can apply the rule to my real problem.

In A1, I've defined a data-validation (list/range) of which the values can
be SUN, MON, TUE, WED, THU, FRI, and SAT. (arrival day)
In B1, I've defined a data-validation (list/range) of which the values can
be SUN, MON, TUE, WED, THU, FRI, and SAT. (departure day)

I need to determine a total dollar-amount depending upon the arrival day and
the departure day (i.e., how long the technician is on-site). I suppose that
I could "hard-code" the values for 49 different combinations. But is there a
formula that can determine the value by looking at the "intersection" of a 7
x 7 table (A1:H8)? I can populate the values relatively easily. But can a
formula (in cell C1, for example) "look" at the corresponding intersection of
a column and row (e.g, arriving MON and departing FRI) and get the value
from that intersected cell? I don't want to do this in a macro. I want to
do it in a formula.

Thanks for any suggestions.