S.I/Lisp/

MEETSCRITERIA




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