Using GETPIVOT DATA

[JakeMann]

Hello,

I'm trying to use a getpivotdata formula to extra certain information.

On the attached sheet in page 'Stock Report' in column M4 i need a program/formula that looks at the description in E3, goes into the page 'Age of Stock', matches that description and returns the date applicable to that description.

My usual GETPIVOTDATA Formula doesn't appear to work - =GETPIVOTDATA("Pallet Qty Update",'Age of Stock'!$A$1,"Stock Item",E3).

Any help would be greatly appreciated.