irishryano
New Member
- Joined
- Jul 27, 2007
- Messages
- 1
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
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