Assuming you are describing a mileage chart.

See this google search thread result for a few methods of doing this.

If you have the duplicate names already entered in Column A and B you can go
with the intersection operator method I describe.

http://snipurl.com/rxtp


Gord Dibben MS Excel MVP

On Sun, 18 Jun 2006 10:13:55 -0500, phil2006
wrote:


If I have a grid with a list of places in the left hand column and along
the top how can I get the value from the grid to insert itself into a
column when the two places are in the column. Thus if I enter two
places into the relevant columns the distance between them shall appear
from the grid?