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 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 |
All times are GMT +1. The time now is 06:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com