calculate km's between two cities

M

Michelle

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
 
B

Bob Phillips

And where will the info come from?

--
---
HTH

Bob

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

L. Howard Kittle

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
 
Top