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

**srgtennis** · 06-29-2012, 02:54 PM

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.

**srgtennis** · 06-29-2012, 05:18 PM

How would I use a sumifs formula to do this?

**srgtennis** · 07-02-2012, 08:09 AM

I need to seperate the information by grower and transfer it over to different sheets. Anyway I can do this?

**srgtennis** · 07-02-2012, 05:14 PM

anybody have an idea?

**srgtennis** · 07-03-2012, 09:11 AM

I tried using index match function, I got it to pull the grade over but it would only do the first grade. I have a grower with a lot of grades and need it to transfer all of them over.

**srgtennis** · 07-03-2012, 11:44 AM

This is the formula I tried to use:

=INDEX('[2012 Tart Cherry Check Grades.xlsx]Master SC'!$U$6:$U$1000,MATCH('[2012 Tart Cherry Check Grades.xlsx]Master SC'!$E$10,'[2012 Tart Cherry Check Grades.xlsx]Master SC'!$E$6:$E$1000,0))

It worked but would only transfer the grade from the top one and not the rest.

*The 2012 tart cherry check grades is the sample master sheet on here.

How can I get it to transfer the grower 2 to the other sheet. So everytime I enter in grower 2 it will transfer the information.

**srgtennis** · 07-06-2012, 10:03 AM

Does any one have a better way or tell me what is wrong with the formula because it will pull only 1 grade and if I drag down it doesn't work.

**srgtennis** · 07-09-2012, 01:00 PM

Why will it only pull one grade over and over and not all of them?

**srgtennis** · 07-09-2012, 02:38 PM

Here is the formula, I figured it out myself:

=IF(ROWS($A$2:$A2)>COUNTIF('[2012 Tart Cherry Check Grades.xlsx]Master SC'!$F$6:$F$1000,"Riley Orchards"),"",INDEX('[2012 Tart Cherry Check Grades.xlsx]Master SC'!$U$6:$U$1000,SMALL(IF('[2012 Tart Cherry Check Grades.xlsx]Master SC'!$F$6:$F$1000="Riley Orchards",ROW('[2012 Tart Cherry Check Grades.xlsx]Master SC'!$F$6:$F$1000)-ROW('[2012 Tart Cherry Check Grades.xlsx]Master SC'!$F$6)+1),ROWS($A$2:$A2))))

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

LinkBack

Thread Tools

Rate This Thread

Display

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

Re: I need to take certain information and trasfer it over depending on what grower I use.

Re: I need to take certain information and trasfer it over depending on what grower I use.

Re: I need to take certain information and trasfer it over depending on what grower I use.

Re: I need to take certain information and trasfer it over depending on what grower I use.

Re: I need to take certain information and trasfer it over depending on what grower I use.

Re: I need to take certain information and trasfer it over depending on what grower I use.

Re: I need to take certain information and trasfer it over depending on what grower I use.

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

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions