Re: Numbers – Look-Up a Value in a Worksheet
Re: Numbers – Look-Up a Value in a Worksheet
- Subject: Re: Numbers – Look-Up a Value in a Worksheet
- From: Christopher Stone <email@hidden>
- Date: Fri, 10 Feb 2017 13:05:32 -0600
On Feb 10, 2017, at 05:45, Yvan KOENIG <email@hidden> wrote:
(1) the instruction set theRow to theCell's row is useless
Hey Yvan,
That was supposed to be:
set rowNum to theCell's row's address
I must have pasted from an earlier attempt.
(2) The instruction tell tables lets think that the script search in every table available in the current sheet. It doesn't.
Zoiks! Sure enough. Doing that reveals an oddity. length of theCell = 1 is accepted when the script use tell tables, it's not when it use tell table 1. It's due to the fact that the functions count and length aren't completely identical. If I replace length theCell = 1 by (count theCell) = 1 the script works.
That's happening, because theCells is no longer a list.
I'll just replace it with this:
set theCell to cells whose formatted value is lookupValue
Because I'll want to be able to catch instances if/when the lookup value is in the table more than once.
Thanks.
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden