I have a workbook, and trying to arrange a dependent drop down list to product name and company. Problem is that, product names (named ranges or groups? I don't know how I should call them) are placed in different sheets in the same workbook and they have multiple words. Addition to this, in the main sheet, product company and product name are placed in different cells. After a couple of hours, my work returned no success. I do need help. Thank you. Sample is in the attachment.