Could you please check the attached file, it has a Pivot sheet with values, which I would like to vlookup on Sheet1.
The pivot is special from that point of view, that it has four sums, and the product is always in the first line of sums so at Sum1. But I would need from those always the Sum4 value.
Do you have maybe idea how to do this with vlookup? On Sheet1 I copied manually these Sum4 values.