Hi Mark

You have to use
=IF(ISERROR(yourGPDformula),"",yourGPDformula)

--
Regards
Roger Govier

"mark" wrote in message
...
Hello.

I have a GetPivotData function, as such:

=GETPIVOTDATA("PROPOSED_AMOUNT",$A$1,"ITEM_NUMBER" ,"00424400-01","PROMISED_MONTH","2008_08")


But, I don't want to use a hardcoded ITEM_NUMBER and PROMISED_MONTH . I
want to use a list of rows for the ITEM_NUMBER and a set of column headers
for the PROMISED_MONTH input.

That part's easy enough, but the input list of item numbers is not the
same
list, in total, as the list of items in the Pivot Table. Some of the
items
in the list are in the Pivot Table, and some are not.

For the items that are in the Pivot Table, I get the proper number... for
the items in the list that are not in the Pivot Table, it returns #REF.

I could probably write my own function to return 0 or " " when the item is
not in the Pivot Table, but is that how GETPIVOTDATA is supposed to work?

Thanks,
Mark