Hi all,
I have a vague idea, but wanted a second opinion to see if its possible.
Let's say I have a massive list of data, contains product types, locations, serial numbers and so on. What I want to do, is be able to say, on another sheet, show me all of this product type and then have a copy of all the rows appear below, or if I only want the stock from a particular location, it shows them only.
So, if I have vending machines across multiple states, but I only want to see the ones that are in state A, would a an index function be the best fit for that.
The first image, would be the look up setting, the second would be the data list. Any help would be wonderful
I have a vague idea, but wanted a second opinion to see if its possible.
Let's say I have a massive list of data, contains product types, locations, serial numbers and so on. What I want to do, is be able to say, on another sheet, show me all of this product type and then have a copy of all the rows appear below, or if I only want the stock from a particular location, it shows them only.
So, if I have vending machines across multiple states, but I only want to see the ones that are in state A, would a an index function be the best fit for that.
The first image, would be the look up setting, the second would be the data list. Any help would be wonderful