=INDICES({"a","c"}, {"a","b","c"}) -> {1,3} =INDICES({"a";"b"}, {"a";"b";"c"}) -> {1,2}
DEFINE( INDICES, LAMBDA( subset, superset, LET( vertical_subset, IF( HORIZONTAL?(subset), TRANSPOSE(subset), subset), vertical_superset, IF( HORIZONTAL?(superset), TRANSPOSE(superset), superset), MAKEARRAY( COUNTA(vertical_subset), 1, LAMBDA( row, _col, MATCH( INDEX( vertical_subset, row, 1), vertical_superset, FALSE))))))
Help us optimize this function