View original (French)

VLOOKUP from a Pivot Table

aideexcel -  
Le Pingou Posted messages 12274 Registration date   Status Contributor Last intervention   -
Hello,

I need to retrieve values from a Pivot Table

I tried the VLOOKUP, GETPIVOTDATA, and SUMPRODUCT formulas but I'm not succeeding

In the Load Forecast tab, I need to retrieve the data from the Summary tab to know the daily times for rows H and V

4 answers

  1.
    Le Pingou Posted messages 12274 Registration date   Status Contributor Last intervention   1 476
     
    Hello,
    Can you provide an example?

    --
    Regards.
    The Penguin
    0
    1. aideexcel Posted messages 5 Status Member
       
      0
      1. aideexcel Posted messages 5 Status Member > aideexcel Posted messages 5 Status Member
         
        0
    2. aideexcel Posted messages 5 Status Member
       
      For example, I would like to retrieve the "0.031" from row H and column May 18, in order to pass it to the red box in the first table

      VLOOKUP does not work
      0