K
Kay
Hi everyone,
I have a pivot table for training records that uses the Emp ID field as the
Page Filter. I want to be able to look up data based on the page filter
choice on another spreadsheet. If I create a tupical VLookup, I get an NA
=VLOOKUP(B4,'Education Info'!A2:$C$400,2,FALSE). GetPivotData Function is
activated, but it does not show that. First of all, can I lookup data from
anoather sheet based on the filter results of the EMP ID field? Second,
should I begin with get pivot data function? Any help would be appreciated.
Thanks!
I have a pivot table for training records that uses the Emp ID field as the
Page Filter. I want to be able to look up data based on the page filter
choice on another spreadsheet. If I create a tupical VLookup, I get an NA
=VLOOKUP(B4,'Education Info'!A2:$C$400,2,FALSE). GetPivotData Function is
activated, but it does not show that. First of all, can I lookup data from
anoather sheet based on the filter results of the EMP ID field? Second,
should I begin with get pivot data function? Any help would be appreciated.
Thanks!