Grid

[phil2006]

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

 

[Gord Dibben]

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

 

[phil2006]

It is a distance chart, but I need to essentially enter a value from th
table when I type the corresponding plsaces in.
For example; using the following table

Spain Brazil India
Spain 25 30
Brazil 25 50
India 30 50

I then need to insert the value from the table into coulumn 3 whe
column 1 and 2 match on the table.
i.e.

Col1 Col2 Col3

Spain Brazil 25
Brazil India 50


Any further help would be very much appreciated