Can I use a 'lookup' to a Pivot Table?
 

I am attempting to compare one column of data (a list Employee numbers)
to another (on a different sheet in the same workbook, also of Ee #s
but not as complete) and put the number in the corresponding cell back
to the original spreadsheet. Since the lists aren't exact, I can't
simply do an (='other sheet'!A1)and drag it down. The lists are both
formated as numbers and in numerical order but not the same length.
The oddity is that the sheet I'm referencing to is a Pivot Table. I'm
getting a #N/A message.

Thanks in advance

You could use the GETPIVOTDATA function:

=GETPIVOTDATA("Units",Pivot!$A$7,"Employee",C3)

or a VLOOKUP:

=VLOOKUP(C3,Pivot!$A$7:$E$17,5,0)

where C3 is the value on the active sheet, and the pivot table is on the
Pivot sheet

Chrism wrote:
I am attempting to compare one column of data (a list Employee numbers)
to another (on a different sheet in the same workbook, also of Ee #s
but not as complete) and put the number in the corresponding cell back
to the original spreadsheet. Since the lists aren't exact, I can't
simply do an (='other sheet'!A1)and drag it down. The lists are both
formated as numbers and in numerical order but not the same length.
The oddity is that the sheet I'm referencing to is a Pivot Table. I'm
getting a #N/A message.

Thanks in advance



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html