Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2012
    Posts
    2

    Unanswered: Perform a vlookup before moving to a pivot table

    Hi, I have a sheet with 2 colums, Employee Id and Located

    employee ID | Located |
    123 yes

    I have another sheet that has 2 colums. Employee Id and Employee Name

    Employee ID | Employee Name |
    123 | John Doe |


    I want a pivot table that look like this:

    Employee ID | Employee Name | Count of located
    123 | John Doe | 15


    apparently i cannot use vlookup within the pivottable. So how can I go about getting the pivottable to dynamically associate the employee id with the employee's name?

  2. #2
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    I would do a vlookup on your second sheet to look up the "Located" field. I would also probably use concatenate to combine the Employee ID and Employee name into something like "123 - John Doe" and then do a pivot table based on that data set.

  3. #3
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    Here's what I mean.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •