I am trying to create a dropdown based on categories and subcategories I have already created, using OFFSET, MATCH, and COUNTA.

[raybeiler1]

On the items sheet, in the Sub-Category Column I am trying to create a data validation dropdown which includes only items that have the category assigned to them which I have already assigned on this sheet. My category and subcategory lists are on the Dropdowns sheet.