Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Please help...
I have this pivot table: Check Date 12/31/09 Hours Worked DepartmentId EeoClass Sex Employee ID Total 200 1 M JONES001 40 300 1 M JOHNSON0001 40 500 1 F JEN001 40 M DOUBLA00001 40 GER001 40 LUK001 40 SMITH000001 40 2 F BOU001 40 Grand Total 320 EEOC is actually the column with 1 and 2 and the vlookup is: Code Description 1 White 2 Black or African American 3 Hispanic or Latino 4 Asian 5 American Indian or an Alaskan Native 6 Native Hawaiian or other Pacific Islander 7 Two or more races I am having an issue using the vlookup with a pivot table. I have seen it used in the past but not working for me. Thanks so much to anyone that can help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
LookUp on a Pivot table | Excel Worksheet Functions | |||
Pivot Table lookup | Excel Worksheet Functions | |||
Lookup within Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Can I use a 'lookup' to a Pivot Table? | Excel Discussion (Misc queries) |