Pivot table and lookup

[SWF13]

Hello,

I run a report which i then put into a pivot table and lookup the values on a seperate sheet, however when i do the report for different clients the columns change and my lookup is wrong. Is there any way to get around this? Ive tried sumproduct but if the table size changes it doesnt seem to work.

Thanks

 

[paddydive]

Why dont you try vlookup with Match, (match the header of colomn)

 

[mtskv5]

You could use a indexing function to grab the data from the pivot tables source data.

 

[paddydive]

Oh yes ! that is also a good option thank mtskv5