https://quadexcel.com/wp/excel-2013-powerpivot-basics-13-replace-3-way-lookup-array-formulas-for-1-2-million-rows-of-data/
Excel 2013 PowerPivot Basics #13: Replace 3 Way Lookup Array Formulas for 1.2 Million Rows of Data