Help with a formula

Copper 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

@Doug_Gillotte 

How about

 

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

 

or

 

=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.