formula help with pivot tables required

**JakeMann** · 08-21-2012, 05:28 AM

Hello,

I am working on a stock control system and need help with a few formulas.

I have attached a document. On page "Template 2" I have a list of material codes and widths. Under column D I need a formula that looks into page "Stock Data". On that page is a pivot table summarising materials codes and widths with a sum of available stock. The formula I need should match the Material Code and Width on "Template 2" sheet and return the appropriate stock figures.

Any help would be greatly appreciated.

Thanks
Jake

**vishnu01445** · 08-21-2012, 06:27 AM

you can do it with Getpivot function. Please find the attached sheet.

**JakeMann** · 08-21-2012, 06:38 AM

Wondeful! Thank you

**vishnu01445** · 08-21-2012, 06:42 AM

Thank you..

**JakeMann** · 08-21-2012, 10:24 AM

I'm wanting to develope this spreadsheet further.

On ther reattachment I've put another page in called "Order Book" and there's a Pivot Table on that page summarising the data.

What I'd like to do on the "Template 2" page is match the material and width from the pivot table in the "Order Book" and return the data in the job name column into the job name column on "Template 2".

I've tried a GETPIVOTDATA formula but I must be doing something wrong...