Lookup to pull a range of cells from pivot table into another sheet.

Copper Contributor

In Excel for Mac 2016, how do I lookup and output the values of multiple cells, one value per cell?

 

Each month I build two pivot tables. I'd like to pull data from one into the same sheet as the other. Please see attached.

Capture101.JPG

0 Replies