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! |
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 |