I was searching for a while excel function currently using Excel 2021. LAX worksheet from C6:R972 is the data range & total column are 16 Match column in Worksheet say test is A3:A1752 against worksheet LAX C6:C972. I would like to get the result from E,K,Q,R column of LAX worksheet
=LET(z,LAX!C6:R972,l,A3:A1752,FILTER(FILTER(SORTBY(z,MATCH(INDEX(z,,16),l,)),SEQUENCE(ROWS(z))<=ROWS(l)),{0,0,1,0,0,0,0,0,1,0,0,0,0,0,1,1}))
I am getting a wrong result: File Link