Debra,

How about NA for the records that do not have a match? You are right, the
formula is correct. I just didn't look at the data carefully enough. There
are training records for inactive employees that should be taken out of the
database. I became hung up on the limitations of pivot tables that I did not
look for the obvious.

thanks for your help

"Debra Dalgleish" wrote:

Your formula looks okay, and you shouldn't need to include the
GetPivotData function.
Are the IDs numbers? Maybe they're being treated as numbers in one
table, and as text in the other table.

If that's the problem, there are instructions here, to change text to
numbers:

http://www.contextures.com/xlDataEntry03.html

Kay wrote:
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!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html