I was getting help from someone but they are no longer replying to messages.
With the following formaula, I can't work out how to add in an additional map range without getting a filter error shown below. Right now it's only looking at 'TAB1'!L:L, needing help to include 'TAB1'!Q:Q.
FILTER has mismatched range sizes. Expected row count: 523. column count: 1. Actual row count: 1, column count: 1.
=sort(filter(hstack('TAB1'!B:C,ifs(regexmatch('TAB1'!L:L,textjoin("|",1,Events!G:G)),"YES",regexmatch('TAB1'!L:L,'TAB1'!Q:Q,textjoin("|",1,Events!H:H)),"NO",1,)),'TAB1'!A:A=A1,regexmatch(A2,map('TAB1'!L:L,lambda(Σ,if(Σ="",,textjoin("|",1,index(if(len(offset(Σ,,1,,4)),Σ&" "&offset(Σ,,1,,4),)))))))),3,)
Is my worksheet, and working from the Help tab.
Trying to have to ranges being looked at not just one. Right now it's only looking at 'TAB1'!L:L but I need 'TAB1'!L:L and 'TAB1'!Q:Q