MicrosoftSergeiBaklan Thanks again for the Trick Sergei !
I used the following to achieve my 1st goal.
'=FILTER(INDEX(A6:BU10,SEQUENCE(ROWS(A6:BU10),1),XMATCH(A29:F29,A5:BU5)),BB6:BB10="Y"). Worked Perfectly
Now in C35 =FILTER(INDEX(A6:BU10,SEQUENCE(ROWS(A6:BU10),1),XMATCH(A29:F29,A5:BU5)),(H6:H10=K35:K37))
In actual scenario K35:K37 is a named range, which keeps on increasing with the addition of Bilty Numbers. In that way if we need to cull a list of desired columns for desired bilty numbers, we can do that and fetch the desired data. But it is not working somehow.
I also tried the following, but not able to untangle the mystery.
C35 = FILTER(A6:BU10,SUMPRODUCT((H6:H10=K35:K37)*1),"")
C35 = =FILTER(INDEX(A6:BU10,SEQUENCE(ROWS(A6:BU10),1),XMATCH(A29:F29,A5:BU5)),ISNUMBER(MATCH(K35:K37,H6:H10,0)))
Hope you can shed some light.
Kanwaljit
