Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PIvot Tables 2003 and VLookup
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PIvot Tables 2003 and VLookup
Here is another version of the formula
=VLOOKUP(GETPIVOTDATA("Employee ID",B4),Lookup,2,FALSE). Hope this clarifies what I am trying to do. "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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
PIvot Tables 2003 and VLookup
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
PIvot Tables 2003 and VLookup
Debra,
Thanks for responding. both fields in each worksheet are formatted with a general format. "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
PIvot Tables 2003 and VLookup Problem Solved
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
PIvot Tables 2003 and VLookup Problem Solved
Thanks for letting me know how you solved the problem.
After you clear the names from the database, you can use the instructions here, to remove them from the pivot table dropdown lists too: http://www.contextures.com/xlPivot04.html Kay wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 pivot tables in 2003 | Excel Discussion (Misc queries) | |||
Pivot Tables and VLOOKUP | Excel Worksheet Functions | |||
Excel 2003 Pivot tables | Excel Discussion (Misc queries) | |||
Pivot Tables - Excel 2003 | Excel Discussion (Misc queries) | |||
Vlookup in pivot tables | Excel Worksheet Functions |