Lookup Distance Matrix

[mohitspamz]

Hey!
Back with another problem! :P

I'm updating my database of distances between different cities in our records... but the source that i have to lookup is actually a distance matrix....something like this...

From/To Mumbai Pune Delhi Kochi Banglore
Mumbai 0 240 1450 1800 900
Pune 240 0 1550 1650 700
Delhi 1450 1550 0 2800 2400
Kochi 1800 1650 2800 0 500
Banglore 900 700 2400 500 0

Now i need to lookup the values contained within the matrix to get distances between them. I'm hoping if i can do that i dont have to actually manually sit and list down all the possible combinations of cities and distances between them but directly lookup the distances from this matrix...

Any leads on this would be great to help me get started!

Regards
Mohit

[DonkeyOte]

Can you outline some examples - better yet post a sample workbook and demonstrate how you intend to use the matrix (ie illustrate where criteria values are being entered etc) -- all a tad vague I'm afraid.

In essence retrieving the value is not difficult - an INDEX with 2 MATCH functions embedded to calculate row column, eg

=INDEX($B$2:$F$6,MATCH("Delhi",$A$2:$A$6,0),MATCH("Bangalore",$B$1:$F$1,0))

obviously references to From/To can be cell references containing the relevant locations.

[mohitspamz]

Perfect!
I just wanted to know how it works conceptually... rest trimming and looking up cities i'll manage!

Thanks for that formula!

Regards
Mohit