Hello,
I am not entirely sure what im looking for to accomplish what i want to do, hence why im here. my problem is i have an ever changing inventory system it is 3 columns infinitely long. (column A,B,C) Column A is for Dates Column B is the name of the produce (many reoccurring names) and column C is for the SKU's of the product. what i want to be able to do is have a drop down list i can chose a name from and it will display all the SKU's that pertain to that specific item. so i have something like this:
A | B | C
8/1/1 |Item A |2090100
8/1/1 |Item C |2180101
8/1/1 |Item A |6090101
i want a drop down menu i can chose from a range of item names and it puts the corresponding SKU's in a list, the first number of the SKU is irrelevant, the second,third and fourth numbers are what the item is(EX, Item A 090, Item C 180) but the list shows up as shown above. the dates don't matter for this list just the SKU pertaining to the selected item.
thanks.
Bookmarks