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
InsertNameCreate. 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"
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
|