Hi,

For a quite sometimes I am using the two formula in two different worksheet extracted pulling data from different worksheet.Below are the formula-

In 1st Worksheet-
=FILTER(INDEX('P-New'!A4:AY51005,SEQUENCE(ROWS('P-New'!A4:AY51005)),XMATCH(A4:O4,'P-New'!A3:AY3)),ISNUMBER(SEARCH(A1,'P-New'!B4:B51005))*ISNUMBER(SEARCH(E1,'P-New'!G4:G51005))*ISNUMBER(SEARCH(F1,'P-New'!AP4:AP51005)),"No Data")
In 2nd Worksheet-
=FILTER(INDEX('L-New'!A4:X15485,SEQUENCE(ROWS('L-New'!A4:X15485)),XMATCH(A4:S4,'L-New'!A3:X3)),ISNUMBER(SEARCH(F1,'L-New'!H4:H15485))*ISNUMBER(SEARCH(F2,'L-New'!H4:H15485))*ISNUMBER(SEARCH(F3,'L-New'!H4:H15485))*ISNUMBER(SEARCH(E1,'L-New'!G4:G15485))*ISNUMBER(SEARCH(D1,'L-New'!F4:F15485))*('L-New'!D4:D15485>=A1),"No Data")
I cannot Fix 2nd formula at specific cell in 1st worksheet becoz the formula of 1st worksheet result get dynamically increases/decreases.

How this can be done.