Forum Discussion

Shane_Devenshire's avatar
Shane_Devenshire
Copper Contributor
Dec 08, 2019

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

Resources