The easiest would be to use the original table (input to the
Pivottable)

=INDEX(E6:E37,MATCH(A1&CHAR(1)&B1&CHAR(1)&C1&CHAR( 1)&D1,A6:A37&CHAR(1)&B6:B37&CHAR(1)&C6:C37&CHAR(1) &D6:D37,0))
Confirm the formula by holding down Ctrl and Shift, then hit Enter.

See enclosed zip-file

Hope it helped
Ola Sandström


+-------------------------------------------------------------------+
|Filename: Book4.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3478 |
+-------------------------------------------------------------------+

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378233