Update VLOOKUP result each time the pivot table is changed

[Herminne]

Hi everyone,

my VLOOKUP formula in the Sheet1 is getting the value from the pivot table in the other sheet. The slicers from pivot table are located in the Sheet1. I'd like the content of the cell with the VLOOKUP formula to change each time the pivot table displaying different value (for instance, when the slicer with the employee name is selected)

do you know the way how to do it?

My formula: =IF(ISNA((VLOOKUP(M3,Sheet5!$A:$C,3,0))),0,(VLOOKUP(M3,Sheet5!$A:$C,3,0)))

Many thanks in advance!

 

[Dave87]

Can you share a picture (including rows and columns references) or in XL2BB please

 

[jbesclapez]

Hi everyone,

my VLOOKUP formula in the Sheet1 is getting the value from the pivot table in the other sheet. The slicers from pivot table are located in the Sheet1. I'd like the content of the cell with the VLOOKUP formula to change each time the pivot table displaying different value (for instance, when the slicer with the employee name is selected)

do you know the way how to do it?

My formula: =IF(ISNA((VLOOKUP(M3,Sheet5!$A:$C,3,0))),0,(VLOOKUP(M3,Sheet5!$A:$C,3,0)))

Many thanks in advance!

Hermine,
TBH it is difficult to understand but I can guess that the Column number is changing no? That means in your example that the 3 is changing...
So, make a variable out of it using a COL function
Hope it helps

 

[Herminne]

Thank you everyone, the issue was that Calculation Option for the formula was set to manual, that's why it didn't work