3 dimension lookup problem
 

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 |
+-------------------------------------------------------------------+

--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=522161

3 dimension lookup problem
 

=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 |
+-------------------------------------------------------------------+

--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522161