Forum Discussion
Index and Match with a pivot table
Hi, I am working on making our sales reports less manual entry and want to use formulas to grab from a pivot table that has all our data. The pivot table currently contains three of the seven...
I would suggest that you use GETPIVOTDATA(). It's a lookup function designed for pivot tables.
And IFNA() should be the outermost function.
Thanks, I'll give that a try today!