Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need information from a cell intesected by a column and row.
I need a formula that will read information from two cells of a sheet then
find the information in a cloumn and row of a table and gather the information from a cell intesected by the column and row. |
#2
|
|||
|
|||
Let's see if I understand what your asking for.
A1 has some value B1 has another value You want to find the value of A1 in the left column of the the table and and the value of B1 in the top row of the table. Once found, you want to find the intersection of the row of the left column matched value and the column of the top row matched value. If that's correct, try this (assuming your table is contained in C1:G10 =INDEX(C1:G10,MATCH(A1,C1:C10,0),MATCH(B1,C1:G1,0) ) The INDEX function returns the value of the cell at the intersection of a certain row and column of a range. So if the A1 value is 3 rows down and the B1 value is 2 colums across, then the INDEX function will look in the range C1:G10 and find the value of the cell that is in the 3rd row and 2nd column. Does that help? Ron |
#3
|
|||
|
|||
I am not sure if this will cure my ill, but it may get me on the right path.
Thank You "Ron Coderre" wrote: Let's see if I understand what your asking for. A1 has some value B1 has another value You want to find the value of A1 in the left column of the the table and and the value of B1 in the top row of the table. Once found, you want to find the intersection of the row of the left column matched value and the column of the top row matched value. If that's correct, try this (assuming your table is contained in C1:G10 =INDEX(C1:G10,MATCH(A1,C1:C10,0),MATCH(B1,C1:G1,0) ) The INDEX function returns the value of the cell at the intersection of a certain row and column of a range. So if the A1 value is 3 rows down and the B1 value is 2 colums across, then the INDEX function will look in the range C1:G10 and find the value of the cell that is in the 3rd row and 2nd column. Does that help? Ron |
#4
|
|||
|
|||
I am not sure if I can make this work. Let me try to give you the whole
story. I work at a Hydro Electric plant. Our dam has boards on top that pop of during high water. We have to account for the water that goes over the boards and through the space of the missing boards. We have a table that list the amount of water that goes through the boards. The table has the elevations in the left column and the boards missing in the top row. We have log sheet that we put all this information on. We would like to put the lake elevation in a cell on the log sheet and the number of boards in another cell of the log sheet and have a formula that will go to the table and find the intersecting cell and put the information in another cell on the log sheet. Is this possible? "Ron Coderre" wrote: Let's see if I understand what your asking for. A1 has some value B1 has another value You want to find the value of A1 in the left column of the the table and and the value of B1 in the top row of the table. Once found, you want to find the intersection of the row of the left column matched value and the column of the top row matched value. If that's correct, try this (assuming your table is contained in C1:G10 =INDEX(C1:G10,MATCH(A1,C1:C10,0),MATCH(B1,C1:G1,0) ) The INDEX function returns the value of the cell at the intersection of a certain row and column of a range. So if the A1 value is 3 rows down and the B1 value is 2 colums across, then the INDEX function will look in the range C1:G10 and find the value of the cell that is in the 3rd row and 2nd column. Does that help? Ron |
#5
|
|||
|
|||
Actually, that was the kind of structure I guessed you might need.
In your table of data, the lake elevation runs down the left side, the number of boards across the top. Using my example, A1 would contain the lake elevation and B1 would contain the number of boards. If you adjust the formula so that it refers to your actual data table, it will return the flow of water from the table. Does that help? Ron |
#6
|
|||
|
|||
I believe that just may do it.
Thank You for your help. This will help us a lot. "Ron Coderre" wrote: Actually, that was the kind of structure I guessed you might need. In your table of data, the lake elevation runs down the left side, the number of boards across the top. Using my example, A1 would contain the lake elevation and B1 would contain the number of boards. If you adjust the formula so that it refers to your actual data table, it will return the flow of water from the table. Does that help? Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
click on a cell to expand with more information | New Users to Excel | |||
Syntax for inferred cell references | Excel Worksheet Functions | |||
transfering information from one cell to another | Excel Worksheet Functions | |||
Can you conditional format based on information in cell comments? | Excel Worksheet Functions | |||
how can i automatically copy the information in one cell on a she. | Excel Worksheet Functions |