Excel 2007 GetPivotData Function

  • Thread starter Thread starter Mary Fetsch
  • Start date Start date
M

Mary Fetsch

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
 
Thanks a lot!

Bernie Deitrick said:
Mary,

=IF(ISERROR(GETPIVOTDATA(...)),"What you want if the company name doesn't exist",GETPIVOTDATA(....))

HTH,
Bernie
MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GETPIVOTDATA #REF! error XL2003/2010 1
Use cell_ref in place of an item in get pivot data function 2
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Getpivot data dynamic reference 1
GETPIVOTDATA function 1
GetPivotData Multiple Fields 6
Getpivotdata problem 2

Back
Top