vlookup

Q

Questiongirl

Is it possible to use vlookup when the information is in a Pivot Table?

I'd need to compare information from 5 column within a Pivot table to 5
column within a Pivot table and one column that's not part of the Pivot. I'd
like to pull the information from the column that's not part of the Pivot and
put that information on the other spreadsheet but not in the Pivot.
Thank you.
 
Q

Questiongirl

Thanks for the quick reply.

However the information that I would like to move is not in the Pivot table.
It's just in the column next to it. But I need the information from the Pivot
table to compare to the Pivot table in the other Excel workbook to pull the
needed information over from that column.
 
Top