sorry i must have been a little unclear.

i already have a table set up. with the city names as row and column
headers. of course with coulmn headers followed by a 1. so it looks a lot
like a multiplication chart.

so i type

=chatsworth sylmar1

it gives me the intersection wich is 12. works fine.

but what i want to do is simplify it so other people can use it.
so the table with all the values are located at a22 and on. there are over
9000 values.

at the top of the sheet i want to be able to type in A2 the from city, type
in B2 the to city and get the intersected value shown in c2. im looking for
the formula to put in c2 so this can all work. i myself dont have a problem
typing out =chatsworth sylmar1. but other people who i want to use this will
only have to type chatsworth then tab over sylmar1, then enter for the
rusults on the next cell.
hopefully im clear this time. i have a lot of trouble trying to explain
myself.

but im also looking into what JC said. it looks like he understood my trouble.

"tjtjjtjt" wrote:

I'm not sure I understand how your Worksheet is set up. A3 and B3 don't
intersect--they are in parallel columns. Usually there are Ranges of more
than one cell a piece when the Intersection Operator is used.
For instance,
=A4:E4 B1:B5
would return the value in B4 because B4 is contained in both ranges.

The formula you have working likely refers to named ranges. Go to Insert |
Name, Define, and see what cells the Names refer to.

tj

"Slumbering Gorilla" wrote:

im made a mileage chart with many values in it. so now when i type

=chatsworth mission_hills1

it gives me the intersection which is the mileage between the two cities.
works perfectly.

BUT, i want to get it so i type the "from" city in one cell, then the "to"
city in another cell then giving me the intersection value in the third cell.
i typed in the formula

=A3 B3

A3 containging the from city and b3 containing the to city. but it doesnt
work. obviously i do not know how to get this formula to work. need help if
there is an answer.