ExcelBanter - Lookup from a pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Lookup from a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/450578-lookup-pivot-table.html)

Excel Dumbo

Lookup from a pivot table

1 Attachment(s)

Hello Friends,

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

Regards,
Dumbo

Claus Busch

Lookup from a pivot table

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

Lookup from a pivot table

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

All times are GMT +1. The time now is 07:23 PM.