Is there a formula that will populate a cell w/ TEXT based on multiple criteria?

D3: =INDEX(DETAILED_PRODUCT_TYPE,MATCH(A3&C3,OBLIGATION_NUMBER&BORROWER,0)) committed with Ctrl-Shift-Enter

This is an array formula and will return the values expected/required. However, it will be very slow because the Named Ranges refer to entire columns.

You could improve performance by specifying a range rather than a full column. Better still, use a Dynamic Named Range. See the updated example file.


Regards, TMS