Vertical and Horizontal Lookup

[JohnGuts]

All,

I have a stadard mileage chart that has city names in the left most column, Column A (A2:A113) and the same city names along the top row, Row 1 (B1:DH1).

This is used to find the distances between two city's by finding the point where the rows and columns intersect.

What I am trying to do is have the user input a city name and find the 10 closest city's to the input city.

The query would be on a seperate sheet than the mileage data so the user input would be in cell A3 and then I would put the 10 closest cites in A5:A14. I would also need to put the mileage value in the cell next to the city name.

Not sure how to make this happen. Thanks for any help you can provide.

 

[Scott Huish]

This is done with INDEX MATCH MATCH:

Excel Workbook
	A	B	C	D	E	F	G	H	I
1		Portland	Salem	Ashland			Start City	End City	Distance
2	Portland	0	30	150			Portland	Ashland	150
3	Salem	30	0	120
4	Ashland	150	120	0
Sheet1

 

[JohnGuts]

Thanks for the reply. This worked great for finding the distance between two specific cities. Any idea how I can find the 10 closest cities to a user inputted city?

Thanks again for any help you can provide.

John