Excel 2007 GetPivotData Function
Mary,
=IF(ISERROR(GETPIVOTDATA(...)),"What you want if the company name doesn't exist",GETPIVOTDATA(....))
HTH,
Bernie
MS Excel MVP
"Mary Fetsch" wrote in message
...
In Excel 2007, I'm using the GetPivotData function to get data to one sheet
from company data on another sheet. Sometimes a company is missing, and then
I get #REF! in the GetPivotData cell. Is there a way to incorporate the
GetPivotData function in an IF function, or some other way, to check for the
missing condition? Maybe somehow check for #REF!? Thanks!
|