[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Wrong indices returned using Lookup for cells containing strings
|
From: |
Nicholas Jankowski |
|
Subject: |
Re: Wrong indices returned using Lookup for cells containing strings |
|
Date: |
Wed, 21 Oct 2015 08:21:28 -0400 |
On Oct 21, 2015 7:43 AM, "Francesco Potortì" <address@hidden> wrote:
>
> >So sorting seems to solve the problem. Thank you guys.
>
> Yes. When doing lookup(TABLE, Y), TABLE must be sorted. This is not
> clear from the docs, I filed a bug report.
>
Hmm, then why did I get the same output for
>> lookup(a,b)
And
>> lookup(sort(a),b)
??
- Wrong indices returned using Lookup for cells containing strings, rcharan51, 2015/10/20
- Re: Wrong indices returned using Lookup for cells containing strings, Olaf Till, 2015/10/20
- Re: Wrong indices returned using Lookup for cells containing strings, Nicholas Jankowski, 2015/10/20
- Re: Wrong indices returned using Lookup for cells containing strings, Olaf Till, 2015/10/20
- Re: Wrong indices returned using Lookup for cells containing strings, Nicholas Jankowski, 2015/10/20
- Re: Wrong indices returned using Lookup for cells containing strings, Nicholas Jankowski, 2015/10/20
- Re: Wrong indices returned using Lookup for cells containing strings, rcharan51, 2015/10/21
- Re: Wrong indices returned using Lookup for cells containing strings, Francesco Potortì, 2015/10/21
- Re: Wrong indices returned using Lookup for cells containing strings,
Nicholas Jankowski <=
- Re: Wrong indices returned using Lookup for cells containing strings, Mike Miller, 2015/10/21
- Re: Wrong indices returned using Lookup for cells containing strings, Olaf Till, 2015/10/21
- Re: Wrong indices returned using Lookup for cells containing strings, Francesco Potortì, 2015/10/22