Help with a formula

New Contributor

I need a suggestion on how to use IFERROR with this formula


=GETPIVOTDATA("Net Cost",'2021 Pivot Tables'!$A$162,"Specialty","EL")


where EL does not currently appear in the pivot but may in the future.


I can't seem to get the FALSE statement placed in the correct spot or with nesting.


2 Replies


How about


=IFERROR(GETPIVOTDATA("Net Cost",'2021 Pivot Tables'!$A$162,"Specialty","EL"),"")




=IFERROR(GETPIVOTDATA("Net Cost",'2021 Pivot Tables'!$A$162,"Specialty","EL"),"-not available-")

@Hans Vogelaar


Thank you! That worked fine.


I thought I had already tried that because that would have been the simplest. Sometimes I overcomplicate the formula.