retreiving values by row and column number within a table?????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

im making a table that looks a lot like a multiplication chart. but the
numbers represent miles. for example, the value in column 9 row 7 = 110.
i have over 9000 seperate values. and i need to find out how i can retrieve
a specified value within the sheet givin the row and column number. can
someone point me to a good tutorial or point me in the right direction.
 
Slumbering said:
im making a table that looks a lot like a multiplication chart. but the
numbers represent miles. for example, the value in column 9 row 7 = 110.
i have over 9000 seperate values. and i need to find out how i can retrieve
a specified value within the sheet givin the row and column number. can
someone point me to a good tutorial or point me in the right direction.
Click to expand...
What do your row and column headers look like?

Alan Beban
 
they are numbered 1 thru 96 on both column and row. just picture a
multiplication table. only the number 1 thru 96 represent cities and the
values within the chart represent mileages between the individual cities. im
still in the process of entering the data(mileages). i want to make so i can
enter the row (from city) and column (to city) then it will get the value of
the grid where those intercept. giving me the mileage.
 
Slumbering said:
they are numbered 1 thru 96 on both column and row. just picture a
multiplication table. only the number 1 thru 96 represent cities and the
values within the chart represent mileages between the individual cities. im
still in the process of entering the data(mileages). i want to make so i can
enter the row (from city) and column (to city) then it will get the value of
the grid where those intercept. giving me the mileage.
Click to expand...
Well, if you change the row and column numbers to city names, then the
following will give you the mileage:

=CityName1 CityName2

Alan Beban
 
Gorilla

Example only....adjust ranges and cities.

You have a table A1:J10

Leave A1 blank.

Say A2:A10 contains city and B1:J1 contains city1

e.g

A2 = Quebec
B1 = Quebec1

A3 = Ottawa
C1 = Ottawa1

A4 = Timmins
D1 = Timmins1

B2:J10 contains mileages.

One method is to select the entire table A1:J10 then choose
Insert>Name>Create, and select top row and left column.

Then use the intersect functionality:

=city city1

In above example =quebec ottawa1

This will return the value of the cell at the intersection of city and city1

Gord Dibben Excel MVP

On Wed, 17 Nov 2004 11:31:02 -0800, Slumbering Gorilla <Slumbering
 
you got it right on the nose Dibben. its working, but i get a null error. but
ill take care of that. i think
 
Back
Top