var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Hi, I have a sheet with 2 colums, Employee Id and Located
employee ID | Located |
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?
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.
Here's what I mean.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors