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...
Shane_Devenshire
Dec 09, 2019Copper Contributor
Hi,
Problem solved - author's mental disconnect.