Vlookup on multiple selections of pivot table and

2019-09-02 15:15发布

I have a pivot table which can select the values for different Quarters in Report filter. Now I'm doing Vlookup based on the selection of quarters on the table. If I select Quarter-1 it is displaying the Quarter-1 (say in cell D5), If select multiple Quarters (Q-1 and Q-2) it is displaying "Multiple selections" in the same cell (D5).

As I'm doing the Vlookup based on the cell D5, it's working fine when I select only single quarter but if I select multiple quarters then it's not working.
So I'm thinking to have the selections of the Pivot table in separate cells to show (Q-1 , Q-2, Q-3 when selected), so that we can do the LookUps?

So Is there any way that I can have the Items of Pivot table which are selected in separate cells??

Example : if I select Q-1 in Pivot it has to populate value Q-1 in call H1 (say) If I deselect Q-1 then It has to remove Q-1 from H1 and same for the remaining, If I select Multiple Quarters then It has to show Q-1 in H1 and Q2 in H2 like that.. and also removing them on deselecting..

0条回答
登录 后发表回答