3 dimension lookup problem

[barkiny]

how can i use sumproduct of other formulas to solve a problem like
that?
i

thanks in advance


+-------------------------------------------------------------------+
|Filename: lookup problem.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4453 |
+-------------------------------------------------------------------+

 

[davesexcel]

=INDEX(A1:E3,MATCH(A8,A1:A3,0),MATCH(B7,A1:E1,0))

place this formula in B8

Your columns heading need to be in one cell
Sales 2006
I have included the formula in your zipped file and showed how the
dropdown menu would work for this sheet


+-------------------------------------------------------------------+
|Filename: lookup problem.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4454 |
+-------------------------------------------------------------------+