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

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

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