MATCH Formula
 

Hi all,

I am using a pivot table to summarise a mass of data. After I create
the pivot table I use formulas to calculate various things. Now as the
pivot table can always have more/less columns/rows I need a way to do a
calculation that will look for the TOTAL GRAND TOTAL in column Q45.

I thought a Vlookup match would work but I do not lookup anything in
the formula. I just need to return the column value of where the total
column meets the grand total column.

PLEASE PLEASE HELP


--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=507621

MATCH Formula
 

Try using the GETPIVOTDATA formula:-

GETPIVOTDATA(data_field,pivot_table,field1,item1,f ield2,item2.....)


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=507621