** I need to know how to do this for work, but didn't want to use our real data, so using this as an example for screenshots
Here's my list on Sheet1:
As you can see, store #124 is listed multiple times because they have a Spotify, Hulu, and Netflix package.
On Sheet2, I want to be able to type in the store# and have the packages and prices populate beneath it:
I also want to be able to change the store number by typing in a different one like this:
In the real dataset I am working on, there are over 12,000 rows and sometimes the "store#" has 10 different "packages". There are also 600+ "store numbers", so I do not want to use a drop down on sheet 2.
I have used the =UNIQUE formula to assign each store# a unique number, but I'm not sure if that's the right thing to do. Similar to the first screenshot, "packages" can be duplicated, too, but the price can be different for each instance of it. I've tried using the MATCH/INDEX functions, but I'm definitely not doing it correctly and I'm struggling to find a tutorial that doesn't use a dropdown.
Any advice is greatly appreciated!
Thanks!
Here's my list on Sheet1:
As you can see, store #124 is listed multiple times because they have a Spotify, Hulu, and Netflix package.
On Sheet2, I want to be able to type in the store# and have the packages and prices populate beneath it:
I also want to be able to change the store number by typing in a different one like this:
In the real dataset I am working on, there are over 12,000 rows and sometimes the "store#" has 10 different "packages". There are also 600+ "store numbers", so I do not want to use a drop down on sheet 2.
I have used the =UNIQUE formula to assign each store# a unique number, but I'm not sure if that's the right thing to do. Similar to the first screenshot, "packages" can be duplicated, too, but the price can be different for each instance of it. I've tried using the MATCH/INDEX functions, but I'm definitely not doing it correctly and I'm struggling to find a tutorial that doesn't use a dropdown.
Any advice is greatly appreciated!
Thanks!
