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!
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!