Using vlookup/hlookup from a Pivot table

[irishryano]

Hi all,

First time posting,
I'm working on a projet for work to determine how many of each component is needed and when to order it.

I've created a pivot table to summarize the data and I'm wondering how to use a vlookup or hlookup to find data associated with a component number. As you know a pivot table puts the component number (reference) in the upper left then 2 columns to the right is the first datum point. Then sequentially lists them below so they are 2 columns over and 1,2,3,4 and 5 rows below the reference cell (component number). I attempted using offsets in conjunction with v/h lookups but I had no success... Anyone know how to use these funcitons together or know of another work around?

Any help would be much appreciated.
Thanks,
Ryan

 

[Norie]

Ryan

Why not use GETPIVOTDATA?

 

[scanavan]

Why not create a unique reference to the left of the pivot table which looks at your component column and says if(b3="",A2,B3). Each time a new componenet is reached, the reference will pull into column a and then each subsequent cell will reference the one above itself.