Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
Right, right, well, you need to use the =getpivotdata() function. Take a
look at this: http://www.youtube.com/watch?v=Lax2x-marRU If that doesn't get you going, search for a couple more 'getpivotdata' videos. It take a bit to get your mind around it at first, but I know soon you will be up to speed with these kinds of things! HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "KarenABS" wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
when you do the VLOOKUP, are you clicking on the referenced cell? If so,
you'll notice the VLOOKUP( will have a whole PIVOTTABLE data set that looks for the specific value. To avoid this, in yoru first set, just manually type the value, so =VLOOKUP(B5, then hghlight your EEOC table ,2,0) HTH! "KarenABS" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
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 | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |