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!

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!

Thanks a lot!

"Bernie Deitrick" wrote:

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!