Create a table in another worksheet.

Put the names of the school in A2:A113
and put the names of the school in B1:DH1
Put the distances between schools in that giant table.
(Kind of like the table you see in maps)

Then you can use a couple of cells with data|validation (use A2:A113) as the
source.
See Debra Dalgleish's site to see how to name that range so that it can be used
as the data|validation list:
http://contextures.com/xlDataVal01.html#Name

Now you can use a formula to return the intersection of those two choices.
Time to visit Debra's site once again:
http://contextures.com/xlFunctions03.html
especially example 2 (or 3)

You may want to put this in your formula:

=if(or(a1="",b1=""),"",index(....))

where a1 and b1 hold the two school names.



chris1978uk wrote:

Hi,

Im creating a similar table showing the distances between 112 schools in our
borough. As this is a very large table of information, I want to have a
simpler worksheet for colleagues to use without scrolling all-over a large
sheet of figures.
I want to have 2 drop-down lists to make a "from" and "to" selection, then
be presented with the distance taken from the table on the other worksheet,
any ideas how I can do this?

Thanks,
Chris

"mkj" wrote:

Hi,

I'm interested in creating a distance table by the easiest possible way in
Excel 2003. With a list of places going down the sheet, can anyone suggest
how I get a formula to copy these cells into other cells going along the top?
I assume this could be adapted or directly used to duplicate distances as
neccassary. For example

Place1 Place2 Place3...
Place1 0 6 4
Place2 6 0 2
Place3.... 4 2 0

Any ideas appreciated.

--

Dave Peterson