You have created a conflicting situation where you placed your inputs and
results in the from locations.

Let's say that the from is in A1, the to is in B1

The from locations are in A2:Z2
the to locationsin A3:A25

=OFFSET($A$2,MATCH(B1,$A$2:$A$25,0)-1,MATCH(A1,$A$2:$Z$2,0)-1)

--
Regards,
Tom Ogilvy


"scrabtree" wrote in message
...
Lets say in sheet 1 the user will type a "From Location"
(i.e. New York) into Cell A1, and a "To Location" (i.e.
Boston) into Cell B1. I want cell C1 to equal the milage.

In sheet 2 there is a distance chart with from location
arranged in Cells A1:Z1. The To Locations are in cells
A2:A25. The row/column intersect contains the miles. You

How can I get cell C1 in sheet one to equal the
corresponding intersect value based on what they typed in
Sheet 1 A1 and B1?

SDC