Vlookup and Pivot table maybe?

[DSL1970]

I have searched the Internet to find an answer to this, but have been unsuccessful. My Pivot Table has 7 rows of data whereas the Internet examples only show 1:

Leader

Type of Unemployment​

Leader 2​

​

Leader 3​

​

Position Level​

FT/PT​

Years of Service​

This is repeated for multiple Leaders.

This has columns Extremely Significant to Not at All Significant based on a question.

My question is, if someone toggles to Years of Service based on my main sheet for a specific Leader 2 or 3 - Do I use a vlookup, or is there a better way of managing this? Can I do this with data validation?

Thanks,

DSL1970

​

​

 

[jscranton]

I have searched the Internet to find an answer to this, but have been unsuccessful. My Pivot Table has 7 rows of data whereas the Internet examples only show 1:

Leader

Type of Unemployment​

Leader 2​

Leader 3​

Position Level​

FT/PT​

Years of Service​

This is repeated for multiple Leaders.

This has columns Extremely Significant to Not at All Significant based on a question.

My question is, if someone toggles to Years of Service based on my main sheet for a specific Leader 2 or 3 - Do I use a vlookup, or is there a better way of managing this? Can I do this with data validation?

Thanks,

DSL1970

​

Do what with vlookup? What are you are trying to do?

 

[DSL1970]

Get the results of the count of each factor, based on dashboard with these measures that can be selected. I want the count of Staff from Leader X within their direct report Leader 2 Y and FT count. So how many FT Staff are their in Leader 2's organization.