RE: intersection formula? need help expanding on it

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Slumbering Gorilla (SlumberingGorilla_at_discussions.microsoft.com)
Date: 11/19/04 

Date: Thu, 18 Nov 2004 17:03:03 -0800

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.

Relevant Pages

  • Re: Printing merged data into 2 columns
    ... I can't seen to get that paragraph mark to delete. ... of the city name does not occur. ... data prints properly in each cell, the height of the cell is too tall. ... Dim source As Document, target As Document, scat As Range, tcat As ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Cell phone Coverage ???
    ... Companies keep making cell phones to do more stuff, ... dinner - soon) and they would become useless if the network signal is not ... not near an interstate or a big city, ...
    (alt.cellular.verizon)
  • Re: extracting info from an address block
    ... What seems to happen if I edit this so that I have the formula wizard, I get an error that excel has stopped responding and then it restarts. ... city, st zip ... take 1 cell), or to paste into a cell, and then it would be 3-7 cells. ... The series of digits and or dash that follows the State. ...
    (microsoft.public.excel.programming)
  • Who can help the NYPD with an Excel formula?
    ... On our worksheet, intersections are listed by row, with each row being one intersection. ... Cell A2 contains the name of the intersection, which obviously does not get added to anything. ... we record the number of bus routes that pass through the intersection. ... In addition, will this formula work in both Excel 2003 and Excel 2007? ...
    (microsoft.public.excel.misc)
  • Re: Dropdown list to return different value
    ... the Data/Validation "Source" box in the Excel menu. ... corresponding city "codes" are referenced. ... excel should enter "292" in its place in that cell. ... your dropdown is on Sheet1 in cell B9 ...
    (microsoft.public.excel.programming)