Hi,

Am Mon, 12 Jan 2015 23:02:57 +0000 schrieb Excel Dumbo:

Could you please kindly suggest a lookup formula that references a pivot
table attached ?

try it with SumProduct:

=SUMPRODUCT(--($A$6:$A$45=M3),--($B$6:$B$45=L2),$I$6:$I$45)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional