I think your formulas will be much faster if you will create key columns instead of trying to join them inside array formulas.