Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel find the content of cell using row and column header
Let say I have a matrix with month as header row (2005-10, 2005-11, etc... )
and sales person as column header (Smith, Jack etc...). the value of the matrix is sales amount : 2005-10 2005-11 Smith 500 300 Jack 25 33 can I create a formula that finds the intersection of a row and a column. for ex. find 33 with is : intersection of Jack and 2005-11. thx |