calculate km's between two cities
 

I am trying to do an spreadsheet that will populate in the km's between two
cities, for instance in cells A2 and B2 I have drop down lists of several
different cites. In cell C2 I would like to have the amount of kms between
the two cities chosen in cells A2 and B2 populate into C2

calculate km's between two cities
 

And where will the info come from?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Michelle" wrote in message
...
I am trying to do an spreadsheet that will populate in the km's between two
cities, for instance in cells A2 and B2 I have drop down lists of several
different cites. In cell C2 I would like to have the amount of kms
between
the two cities chosen in cells A2 and B2 populate into C2

calculate km's between two cities
 

Hi Michelle,

If you have a table of the distances between the cities you can use
something like this.

=INDEX(B2:F6,MATCH(H1,A2:A6,0),MATCH(H2,B1:F1,0))

Where B2:F6 are the miles, A2:A6 & B1:F1 are the cities, H1 is the first
city, H2 is the second city.

HTH
Regards,
Howard

"Michelle" wrote in message
...
I am trying to do an spreadsheet that will populate in the km's between two
cities, for instance in cells A2 and B2 I have drop down lists of several
different cites. In cell C2 I would like to have the amount of kms
between
the two cities chosen in cells A2 and B2 populate into C2