Home |
Search |
Today's Posts |
#1
|
|||
|
|||
is there anything to solve this?
Hi!
maybe it is very simple... i don't know... so there are known the distances between two cities, which i write in table example: A B C 1 City1 City2 Distance 2 A B 1 3 A C 2 4 B C 3 5 C A 2 6 D A 4 etc. This can be the source. And table with city names only. A B C 1 City1 City2 Distance 2 A B ?formula? (the source is above) 3 C A 4 C A 5 D A 6 D A 7 A B 8 A B 9 B C 10 B C .... sooo long. Is there any formula to write in the column Distance to fill in with correspending distance from A to B and D to A etc.? I use filters, but this takes very very long. I will appreciate any advise! |
#2
|
|||
|
|||
Assuming the first list has unique entries.
=SUMPRODUCT((Sheet1!$A$2:$A$100=A2) * (Sheet1!$B$2:$B$100=B2), Sheet1!$C$2:$C$100) -- Rob van Gelder - http://www.vangelder.co.nz/excel "Emty" wrote in message ... Hi! maybe it is very simple... i don't know... so there are known the distances between two cities, which i write in table example: A B C 1 City1 City2 Distance 2 A B 1 3 A C 2 4 B C 3 5 C A 2 6 D A 4 etc. This can be the source. And table with city names only. A B C 1 City1 City2 Distance 2 A B ?formula? (the source is above) 3 C A 4 C A 5 D A 6 D A 7 A B 8 A B 9 B C 10 B C ... sooo long. Is there any formula to write in the column Distance to fill in with correspending distance from A to B and D to A etc.? I use filters, but this takes very very long. I will appreciate any advise! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Names can solve my problem? | Excel Worksheet Functions | |||
How to solve a formula so that it returns actual answer if negati. | Excel Discussion (Misc queries) | |||
Circular functions | Excel Worksheet Functions | |||
solver can not solve polynomial eq. where one variable is five di. | Excel Worksheet Functions |