Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
get SQL Server text data type into Excel pivot table | Excel Discussion (Misc queries) | |||
Use Excel to make an update query to another database table? | Excel Discussion (Misc queries) | |||
import web table to excel | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
paste excel table to word | Excel Worksheet Functions |