| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table lookup | Excel Discussion (Misc queries) | |||
| Pivot Table lookup | Excel Worksheet Functions | |||
| Lookup within Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
| Can I use a 'lookup' to a Pivot Table? | Excel Discussion (Misc queries) | |||
Threaded Mode
