| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup
use =getpivotdata( ) function to capture data from pivot table...
On Apr 16, 10:13*pm, Questiongirl wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup
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. "muddan madhu" wrote: use =getpivotdata( ) function to capture data from pivot table... On Apr 16, 10:13 pm, Questiongirl wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Hybrid Mode
