macProVideo.com
Forums
  • Tenuwue
    Posts: 2
    Joined: Apr 11th, 2014, 06:31
    Advanced use of the INDEX function in Numbers
    Hi! I would like to create a database with search fields. I have two sheets in my numbers file: The first is the "database" of choral composers, their compositions, dates, country of origin, ect. My second sheet is is meant to show the information from the database for one composer/person at a time. I.e. - I type a composers' name into a cell and then all of his information shows up in the rest of the page. (essentially the name works as a "key" for the equation.) HOWEVER, I have no idea how to actually make this happen. I have attached a dropbox link to download a copy of what I have. (the file contains a couple of people to use in a test) This is a HUGE undertaking that could significantly help my career. Any help would be GREATLY appreciated! R https://www.dropbox.com/sh/qj0jf9ra89cc9rt/cBYAFvEmpd
    Reply
  • Jedyjuy
    Posts: 1
    Joined: Jun 28th, 2014, 04:11
    Re: Advanced use of the INDEX function in Numbers
    Hello, to be able to download your example file from dropbox, you have to zip it before, because the file structure of the new numbers files is different and cannot be placed on a non-Apple formatted hard drive format (dropbox). Greets.
    Reply
  • Tenuwue
    Posts: 2
    Joined: Apr 11th, 2014, 06:31
    Re: Advanced use of the INDEX function in Numbers
    Wonderful! Here is a new link: https://www.dropbox.com/s/75yxq4bnzwaikb9/Choral%20Literature%20Database%20copy.zip
    Reply
  • thesis writing
    Posts: 1
    Joined: Sep 5th, 2015, 02:09
    Re: Advanced use of the INDEX function in Numbers
    Really a great work.Since the point of this instructional exercise is to exhibit an option approach to do a vlookup in Excel by utilizing a mix of INDEX and MATCH capacities, we won't harp much on their linguistic structure and employments. We will cover just the base essential for comprehension the general thought and after that take a top to bottom take a gander at equation Click here http://laustan.com
    Reply
  • Pasku
    Posts: 6
    Joined: Apr 5th, 2016, 12:28
    Re: Re: Re: Re: Re: Re: Advanced use of the INDEX function in Nu
    don't work this link
    Reply
You must be logged in to post a reply
Recent Threads
Recent Posts
Feedback
Course Advisor
Don't Know Where To Start?
Ask A Course Advisor
Ask Us!
Copy the link below and paste it into an email, forum, or Facebook to share this with your friends.
Make money when you share our links
Become a macProVideo.com Affiliate!
The current affiliate rate is: 50%
Classes Start Next Week!
Live 8-week Online Certification Classes for: