Forum Discussion

Scott Evans's avatar
Scott Evans
Copper Contributor
Sep 13, 2018

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

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.

No RepliesBe the first to reply