Excel-read a table

[Guest]

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

 

[Gord Dibben]

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