Powerpivot Dropdown lookups

Excelmee

New Member
Joined
Mar 2, 2021
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
Hello,

I have 2 spreadsheets - one is a beast, a power query, power pivot data hub that is shared by a large team. It has a dropdown at the top which allows me to select the product that i am interested in. once selected, the data in the sheet will refresh and pull in from the Datacube/model.

My second spreadsheet is simple, but i need to pull data from the first spreadsheet using a lookup (index/match) > say i'm interested in Product A Sales in December in my second spreadsheet, i need it to lookup the sales in december for product A in the first spreadsheet.

The problem i'm facing at the minute is that it works so long as the drop down in the first spreadsheet is on the product in question - if someone goes in and changes the dropdown to look at a different product, my second spreadsheet values will all change.

Does anyone know how to get around this?? I've searched many threads and videos but cant find the answer (or even the question - perhaps i'm not wording it right)


thanks!
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Forum statistics

Threads
1,141,862
Messages
5,709,045
Members
421,609
Latest member
misskittens

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top