[Excel Dumbo]

Hello Friends,

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

Regards,
Dumbo

[Claus Busch]

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

[Claus Busch]

Hi,

Am Tue, 13 Jan 2015 07:50:43 +0100 schrieb Claus Busch:

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

that only works for the row with the name in it.
You better try SumProduct from the source table.


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