I have sheet containing Distances between(137) cities need to know a formula to retrive the same in a new sheet by just feeding the city names.
I have sheet containing Distances between(137) cities need to know a formula to retrive the same in a new sheet by just feeding the city names.
This should do it I think
Cheers
Tom
Hi check it out
starguy
Tahir Aziz
PAKISTAN
https://www.facebook.com/businessexcel
__________________
Forum Rules (read before you post)
Links to the world of Excel
Thanks to starguy and tom moston for their suggestions solves my problem.
R K Sundaram
Thanks to both of you for sharing your solutions (and to the original poster for their question)! I had the exact same challenge, but with fewer cities.
Digging up an old thread here, lol! But I came across a similar challenge, and here is how I managed to solve it.
I used MS Excel 2010, so please beware of any compatibility issues before proceeding!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks