G4 has the following formula, which returns a particular cell in a pivot table located at A15:C30. As you can see, B16 and C16 have particular columns names, so that makes it easy. However I have a new pivot table (A1:E13) which now has two columns with the same name. Does anyone know how to locate the proper cell to read from? See attached spreadsheet
=IFERROR(+GETPIVOTDATA("SL",$A$15:$C$30,"lob_name","Consumer Repair"),"")
Bookmarks