Help with formula from Pivot Table

[Bruno Gil]

Hi everyone,

It would be highly appreciated, if someone could help me with the following:

Let´s say I have a product code 2310 that I want to lookup on a Pivot Table, and to return the value on Column C.

The issue is that under the code 2310 (on the pivot table), I have two other options that I want to lookup for (Available and Not Available). So, what I want, is to retrieve the value on Column C, for the Available and Not available under the code 2310.

If someone could help me it would be amazing!

Many thanks and regards

 

[FormR]

Hi, if, in the cell where you want the formula, you press = and then select the value in the pivot table that you want to retrieve does Excel create a GETPIVOTDATA() function for you?