Forum Discussion

Tom_at_work's avatar
Tom_at_work
Copper Contributor
Oct 28, 2019
Solved

GET PIVOTDATA #REF! error

I am frustrated!  I have posted this question 2 times, but it never appears in my conversations on the community.  Trying again.   I want to use the GET PIVOTDATA function to reference data from wi...
excel
Formulas and Functions
office 365
  • JKPieterse's avatar
    JKPieterse
    Oct 28, 2019

    Depends on what's in T8. If that value isn't in the pivottable #REF! is the result. Please note that you might need to convert the content of T8 to text:
    =GETPIVOTDATA("Amount",'2019'!$R$4,"Fund","1100","Orgn","2002","Acct",T8&"")

JKPieterse's avatar
JKPieterse
Silver Contributor
Oct 28, 2019

Depends on what's in T8. If that value isn't in the pivottable #REF! is the result. Please note that you might need to convert the content of T8 to text:
=GETPIVOTDATA("Amount",'2019'!$R$4,"Fund","1100","Orgn","2002","Acct",T8&"")

Tom_at_work's avatar
Tom_at_work
Copper Contributor
Oct 28, 2019

JKPieterse 

Thanks Jan for your quick response.  Converting to text, based on your syntax worked, but please educated me on "how" this works.  I understand the concatenate function with the & symbol, but I don't understand how the syntax for this statement works.

 

This worked!  Look forward to your response.

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Oct 28, 2019
    Adding an empty string to a number converts that number to a string value.

Resources