Binary search and return all matches as an array

[revs92]

The last argument in XLOOKUP allows performing a binary search but XLOOKUP only returns one match.
IF(value=lookup_array,return_array,"") returns all matches in an array but is slow on large lookup ranges/does not do a binary search.

Would anyone know a fomula - or combination of - that both does a binary search on a sorted range and return all matches as an array?

Thanks in advance!

 

[Fluff]

I doubt you will find anything faster than Filter, regardless of what type of search you do.

 

[revs92]

I doubt you will find anything faster than Filter, regardless of what type of search you do.

I'm afraid so too, but I'll keep searching a little more. I'll reply to this post if I find anything.
Thank you for your suggestions so far

 

[Fluff]

You're welcome.

 

[Fluff]

Not sure how fast this will be, but try

=INDEX(range1,SEQUENCE(COUNTIFS(range2,A2),,XMATCH(A2,Range2,0,2))))

 

[revs92]

Not sure how fast this will be, but try

=INDEX(range1,SEQUENCE(COUNTIFS(range2,A2),,XMATCH(A2,Range2,0,2))))

That's it! Thank you so much Fluff. That formula perfomed about 15 times faster than FILTER in my tests.
Also, I had no idea COUNTIFS would be that fast, and it's apparenytly even faster on sorted ranges.

 

[Fluff]

Glad to help & thanks for the feedback.