Creating a GETPIVOTDATA formula that retrieves dyanmic "items" (as in the syntax [field, item] as defined by a cell reference

[Need_help_in]

Hi All,

I am attempting to create a GETPIVOTDATA formula that retrieves dynamic "items" (as in the syntax [field, item] as defined by a cell reference.

I have written the following formula:

=GETPIVOTDATA("CS Hours", [reference to pivot table in another workbook], "Field Name 1",A2, "Field Name 2", [today's date], "Field Name 3", C2)

What I would like for the result to be is that the GETPIVOTDATA will obtain the value of the "CS Hours" field where "Field Name 1" equals the value of cell A2, "Field Name 2" equals the value of today's date, and "Field Name 3" equals the value of Cell C2.

I would like to define cell reference A2 and C2 as the value of those cells, while referencing them in the [field, item] syntax. The "Field Name 1" field will be defined by the text "Field Name 1", and thus will not need to be dynamic as this is how the field is identified within the pivot table used to look up the value. I attempted to use the INDIRECT function to perform this, but it was to no avail.

Now I question whether the GETPIVOTDATA function is even the correct function to use in this instance. Any assistance would be sincerely appreciated.

Thank you so much for your time and assistance.