Help with a mileage sheet

[Guest]

I am trying to create a mileage sheet, it needs to include a cost center, to
and from and the standatd miles. I have created a document for this to pull
form, but am having problems trying to create the formula. Here is an example
of what I am trying to do.

N. St P. St. X. St
N. St. 0 5 10
P. St 5 0 2

That is on one sheet, I need the data to pull into the other sheet, so if
someone types in

To From Total Miles
N. St P. St (5 - The cell would auto fill with the correct
mileage form the other sheet).

Is there a way to do this? If so, how would I do it? There are approximately
15 different locations on the spreadsheet. Thanks so much!

 

[Gord Dibben]

One method using created names.

Example only....adjust ranges and cities.

You have a table A1:J10

Leave A1 blank.

Say A2:A10 contains city and B1:J1 contains city1

e.g

A2 = Quebec
B1 = Quebec1

A3 = Ottawa
C1 = Ottawa1

A4 = Timmins
D1 = Timmins1

B2:J10 contains mileages.

One method is to select the entire table A1:J10 then choose
Insert>Name>Create, and select top row and left column.

Then use the intersect functionality:

=city city1

In above example =quebec ottawa1


This will return the value of the cell at the intersection of city and city1


Gord Dibben Excel MVP