Excel Pivot table

[regdunlop99]

I have used the same coding before for my pivot table. However, it is not giving me the correct results even if I refresh Data. The Microsoft help person got it to partially work by clicking in the individual cell but the spreadsheet is huge and that is not feasible.

=IFERROR(VLOOKUP(AP2&AO2,PIVOT3!A:D,4,0),"NO")

that is my formula. 

IF my column DZ = YES the Pivot Table should return a number to column EH but it doesn't.

I use AP and AO to combine some numbers so everything will be unique.

not sure if it has anything to do with pasting more rows into the spreadsheet. Totally at a loss any help would be much appreciated.

[#2]

@regdunlop99 

Your formula will either return NO or a number from the fourth column in range A:D in sheet PIVOT3. I wonder where the YES in column DZ is supposed to come from. If it is your formula that populates DZ, try using =IF(ISERROR(VLOOKUP(.......)),"NO","YES")

If, whatever you are looking for is in your pivot table it will return YES otherwise NO. 

[#3]

@Riny_van_Eekelen 

thank you for the response. I will check it out.