I would like to use INDEX MATCH in a BYROW function to populate an entire column with the output of the INDEX MATCH.
There are 2 criteria for the INDEX MATCH function.
Criteria 1 is in row 2 of the current column (indirect(ADDRESS(2,column(),4)), and is looked up in named rang SUG_Drawing.
Criteria 2 is in column 1 of he current row (indirect(ADDRESS(row(),1,4)), and is lookup in named range SUG_EXC_PN.
The function below outputs data from named range SUG_QTY when both criteria are met. This function works as shown in Column J