Basically I have a table with 2 columns, column A contain the company name and column B contains an items list
Company A - Widget 1
Company A - Widget 2
Company B - Widget 3
Company B - Widget 4
I would like to setup a drop down list that references a company name from another cell and lists all the items for that company.
A2 = Company A
Drop down list = Widget 1, Widget 2.
I've played around with and Index Match formula but it only returns the first result and not the array. If I create a named range using the Index Match formula, i'm unable to assign the named range to data validation.
Looking for best way to accomplish this.