Dynamic named range based on two criteria

Yes. You are over complicating things. This sheet replicates what you had, from unsorted data. It's probably not what you want... yet. So in your next post focus on the FINAL outcome rather than your proposed way of getting there...