Hi all,
I do a top 20 analysis where I have a summary page that has a unique ID for each line and 20 tabs( also has unique row ID) where I pivot the 20 individuals. I have to pull the comments from the 20 supporting tabs back to the summary page. I have been doing vlookups . The only way I know to have this template be usable for future months is to nest the lookup from the 20 supporting tabs , which is messy. Does anyone have a suggestion better method? Would power BI have a better solution?Any thoughts would be appreciated
I do a top 20 analysis where I have a summary page that has a unique ID for each line and 20 tabs( also has unique row ID) where I pivot the 20 individuals. I have to pull the comments from the 20 supporting tabs back to the summary page. I have been doing vlookups . The only way I know to have this template be usable for future months is to nest the lookup from the 20 supporting tabs , which is messy. Does anyone have a suggestion better method? Would power BI have a better solution?Any thoughts would be appreciated