If your mileage "chart" is in say, Sheet2, in A1:F6, and your TO and FROM
ranges are in Sheet1, A1 and A2 respectivly, try this:

=INDEX(Sheet2!$A$2:$F$6, MATCH(Sheet1!$A$1, Sheet2!$B$1:$F$1, 0),
MATCH(Sheet1!$A$2, Sheet2!$A$2:$A$6, 0)

or

=VLOOKUP(Sheet1!$A$1, Sheet2!$A$2:$F$6, MATCH(Sheet1!$A$2, Sheet2!$A$1:$F$1,
0), 0)

--
Regards,

Juan Pablo González

"tony" wrote in message
...
I want to able to type a TO and FROM destination on my travel form and
extract the mileage information from the mileage chart of another worksheet.
The mileage chart has the top row naming the cities. The same cities are
also listed on lefthand side column, with the mileage between each city in
the cells. How can I do this?