Can I Use Index Match to Get an AVERAGE of multiple cells?

[Pulseczar]

Hi,

I'm not sure if Index Match can do this and would appreciate some guidance.

I have two sheets inside my workbook:

Sheet1 is where I have a list of players in a baseball league
Sheet2 is where I have a game-by-game breakout of each players stats

Can Index Match be used in this case to index all the data in Sheet2 (Player stats) and quickly give me averages for their data.

• Column A is where I have all the players names in both sheets

• Column F in Sheet2 has the Number of Pitches Thrown

What would my Index Match formula be within Sheet1 to fill in an "Average Pitches Per Game" column?

Thanks in advance.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)