Forum Discussion
Shane_Devenshire
Dec 08, 2019Copper Contributor
xlookup with binary search
Hi Folks, The following formula works: =XLOOKUP("*1*",A:A,A:A,,2,1) but this one doesn't: =XLOOKUP("*1*",A:A,A:A,,2,2) The same data is being used for both and is sorted ascending on A:A. Th...
Wyn Hopkins
Dec 09, 2019MVP
Hi Shane
You can't do a Binary Search with a wildcard option
You can't do a Binary Search with a wildcard option
- Shane_DevenshireDec 09, 2019Copper Contributor
Came to that conclusion after a little thought, thanks!