Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
x and y axis, enter x value, enter y value, value at intersect....
I have a matrix with x axis and y axis
X axis has column headers of A, B, C Y axis has row headers of D,E,F If I enter A in cell a1 (B), and E in cell a2 (G), i want the intersect value (8) to appear in cell a3 A B C E 1 2 3 F 4 5 6 G 7 8 8 Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
x and y axis, enter x value, enter y value, value at intersect....
Assuming Column headers are in B7:D7,
Row headers in A8:10, Data in B8:D10, the formula is: =INDEX(B8:D10;MATCH(A2,A8:A10);MATCH(A3,B7:D7)) HTH -- AP "JcR" a écrit dans le message de ... I have a matrix with x axis and y axis X axis has column headers of A, B, C Y axis has row headers of D,E,F If I enter A in cell a1 (B), and E in cell a2 (G), i want the intersect value (8) to appear in cell a3 A B C E 1 2 3 F 4 5 6 G 7 8 8 Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
x and y axis, enter x value, enter y value, value at intersect
thanks
"Ardus Petus" wrote: Assuming Column headers are in B7:D7, Row headers in A8:10, Data in B8:D10, the formula is: =INDEX(B8:D10;MATCH(A2,A8:A10);MATCH(A3,B7:D7)) HTH -- AP "JcR" a écrit dans le message de ... I have a matrix with x axis and y axis X axis has column headers of A, B, C Y axis has row headers of D,E,F If I enter A in cell a1 (B), and E in cell a2 (G), i want the intersect value (8) to appear in cell a3 A B C E 1 2 3 F 4 5 6 G 7 8 8 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Chart Axis Reversal | Charts and Charting in Excel | |||
3rd Y Axis | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Problem w/Chart Axis labeling with VBA | Excel Discussion (Misc queries) | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel |