• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Numbers – Look-Up a Value in a Worksheet
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Numbers – Look-Up a Value in a Worksheet


  • Subject: Numbers – Look-Up a Value in a Worksheet
  • From: Christopher Stone <email@hidden>
  • Date: Thu, 09 Feb 2017 15:09:34 -0600

Hey Folks,

In Numbers 4.0.5 I figured out how to do a basic lookup and select the found cell.

--------------------------------------------------------------------
# Look Up a Value in a Given Document
--------------------------------------------------------------------
tell application "Numbers"
   tell document "Some Document"
      tell active sheet
         tell tables

            

            set theCell to first cell whose formatted value is lookup

            

            if theCell ≠ {missing value} and length of theCell = 1 then
               set theCell to item 1 of theCell
               set theRow to theCell's row
               set selection range to theCell
            end if

            

         end tell
      end tell
   end tell
end tell
--------------------------------------------------------------------

Is there a more efficient way to do this?

TIA.

--
Best Regards,
Chris

 _______________________________________________
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

  • Follow-Ups:
    • Re: Numbers – Look-Up a Value in a Worksheet
      • From: Yvan KOENIG <email@hidden>
    • Re: Numbers – Look-Up a Value in a Worksheet
      • From: Yvan KOENIG <email@hidden>
  • Prev by Date: Rép: Numbers Daylight Savings Bug Still Active?
  • Next by Date: Re: Numbers – Look-Up a Value in a Worksheet
  • Previous by thread: Displaying Applescripts scroll in the menu bar
  • Next by thread: Re: Numbers – Look-Up a Value in a Worksheet
  • Index(es):
    • Date
    • Thread