4 ms·The "traditional" Excel solution is Array Formulas.by nerdponx 3y agoThe "traditional" Excel solution is Array Formulas.artlessmax 3y agoBut Index/Match doesn’t play nice with array formulas :/