Excel 2007 GetPivotData Function

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!
 
B

Bernie Deitrick

Mary,

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

HTH,
Bernie
MS Excel MVP
 
M

Mary Fetsch

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
GETPIVOTDATA function 1
Getpivotdata problem 2
GetPivotData Multiple Fields 6
GETPIVOTDATA function on pivot filter 0

Top