VLOOKUP from a Pivot Table

Question

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

Le Pingou · Answer

Hello, Can you provide an example?  -- Regards. The Penguin

Raymond PENTIER · Answer

Good evening.

Why these 3 functions in your formula?
A formula with just the VLOOKUP function should be enough if the "Day" column is before the "Time" column.
Otherwise, it will be with the INDEX function.

--
Retirement is nice! Especially in the Caribbean...
Raymond (INSA, AFPA)

aideexcel · Answer

https://img-19.ccm2.net/RXhyqxnCps4XS5ZiCYTMpimG-2A=/440x/c40d691592cc4002bf943fd541db17d4/ccm-ugc/2020-05-15_11_42_55-excel_-_Excel.png

Le Pingou · Answer

Hello, In the cell where you want to retrieve the value, enter: =SUMPRODUCT((A:A="H")*1,B:B)  Adjust A:A and B:B according to the position of your pivot table.  -- Regards. The Penguin

VLOOKUP from a Pivot Table

4 réponses

Windows spotlight is not working.

Masked destination layer

Samsung j5 unable to answer

Scam of the suvedene highway

File name too long

No sound with ps3 and hdmi

Wake up from sleep mode in windows 10.

Internet connection problem with my ipad

Free box: remote control broken

Suspicious number text message