I'm having some issues returning the value into another sheet from a Pivot table using both lookup cells on both sheets.
My main sheet is called "Event Tracker" and need to get data from "SMIS_Data" which are Pivot Tables using the column "A" in "Event Tracker" the count and date information.
- if 9220 in column "A4" of "Event Tracker" is listed in "SMIS_Data" sheet under Near Miss pivot table then return value in E4 and so on. The same is for the date but below only returns values in that column and doesn't look between Pivot SMIS_Data!$A$3 and 'Event Tracker'!A4
Count Events
=GETPIVOTDATA("Count of lc alcrm ref",SMIS_Data!$A$3,"lc alcrm ref",SMIS_Data!A3,"LC Event Category","Near Miss")
Latest Date Event
=GETPIVOTDATA("Max of event date",SMIS_Data!$A$3,"lc alcrm ref",SMIS_Data!A3,"LC Event Category","Near Miss")
Bookmarks