# Vlookup index match across multiple sheets and average values

#### goblue667

##### New Member
I have a list of Golfers in my "Summary" tab where I want my vlookup to find the golfers name in each of the four sheets and then look at a specific column and average those values in the summary sheet. Is this possible? I have been looking around and have not seen anything pertaining to the same index match across sheets....

### Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

#### goblue667

##### New Member

Above is the Summary sheet that I need Finish Position to be averaged across all sheets.

Above is what Sheet 1,2,3,4 look like. I need Column A to Match column A in Summary sheet and then Column B is the values I need averaged.

#### Fluff

##### MrExcel MVP, Moderator
Create a list of the sheets that you want to average & then name it SheetList.
You can then use
=IFERROR(SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!A3:A30"),A2,INDIRECT(SheetList&"!I3:I30")))/SUMPRODUCT(COUNTIF(INDIRECT("'"&SheetList&"'!A3:A30"),A2)),"")

#### goblue667

##### New Member
Create a list of the sheets that you want to average & then name it SheetList.
You can then use
=IFERROR(SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!A3:A30"),A2,INDIRECT(SheetList&"!I3:I30")))/SUMPRODUCT(COUNTIF(INDIRECT("'"&SheetList&"'!A3:A30"),A2)),"")
So create a new tab and list the sheets with their exact names and then call the tab SheetList?

and then put that formula in column B and then fill down?

#### Fluff

##### MrExcel MVP, Moderator
Not quite, you need to create a list of the sheets, on the summary sheet or a new sheet, then select the cells & in the name box type SheetList.

Threads
1,106,626
Messages
5,512,477
Members
408,899
Latest member
cve60069

### This Week's Hot Topics

• Sort code advice please
Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
• SUMPRODUCT with nested If statement
Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
• VBA - simple sort is killing me!
Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
• Compare Two Lists
I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
• Formula that deducts points for each code I input.
I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
• Conditional formatting formula required for day of week and a value
Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...