DEFINE(
MEETSCRITERIA,
LAMBDA(
row_data,
criteria_table,
ALL(
MAKEARRAY(
ROWS(criteria_table),
1,
LAMBDA(
row,
_col,
LET(
function,
INDEX(
criteria_table,
row,
2),
value,
INDEX(
row_data,
1,
INDEX(
criteria_table,
row,
3)),
criterion,
INDEX(
criteria_table,
row,
4),
APPLY(
function,
value,
criterion)))))))
Help us optimize this function