Results 1 to 9 of 9

Excel 2007 : How do I use Index/Match formula to pull certain information?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-02-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    255

    How do I use Index/Match formula to pull certain information?

    I need to take information from the sample master and transfer it to the other book. I want it to take the Grade, Block, and Grader and transfer it over to the right tab in the tart check grades by grower book. There will be a page for each grower so when I enter information in the master book it will transfer to the right grower depending who I put in there. I want it to tranfer over to columns B, C, D.

    Also I would like to keep track of the avg grade for each of the grader on the right in columns F - K. So as the informatino in B - D accumulate then it will change the graders avg.
    The first page I want it to do the same except for all growers.
    Attached Files Attached Files
    Last edited by srgtennis; 07-09-2012 at 02:08 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1