Excel-read a table

How do i create a formula that will read a column and a row and return the
information at the intersection of those two points.

If i am looking for the intersection of C and 3 to return a value of 5.
Where C is in one Cell and 3 is in a diffrent Cell. As if the Answer to two
diffrent question yeilds a response of the intersection point.

1 2 3 4
A 7 9 5 3
B 5 4 3 6
C 9 8 5 1
D 1 1 1 1

DH

Don't know if this would help.......

If you have your rows and columns named you can use the intersection operation
to find a value.

Or if you have labels, say across row 1 and down column A you can use them to
create an intersection table.

i.e.

A2:E5 have data.

B1:E1 have title1, title2, title3, title4

A2:A5 have item1, item2, item3, item4

Select A1:E5

Insert>Name>Create. Check top row and left column.

Now in H4 enter =title2 item3

Works great for mileage charts and similar operations but might not be
applicable for your needs.


Gord Dibben Excel MVP

On Mon, 26 Sep 2005 11:16:10 -0700, "DHS64" <DHS64@discussions.microsoft.com>
wrote:

>How do i create a formula that will read a column and a row and return the
>information at the intersection of those two points.
>
>If i am looking for the intersection of C and 3 to return a value of 5.
>Where C is in one Cell and 3 is in a diffrent Cell. As if the Answer to two
>diffrent question yeilds a response of the intersection point.
>
> 1 2 3 4
>A 7 9 5 3
>B 5 4 3 6
>C 9 8 5 1
>D 1 1 1 1