matthewdrhodes
New Member
- Joined
- Sep 26, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I'm trying to get one drop down cell that matches a particular column in a range of data & another cell that matches a different column in that range.
Example:
Page 2
Page 1
I'm trying to figure out how to write an equation that goes in the red text area of Page 1 that calculates all of Page 2 range that matches athlete name in column A of page 2 to the athlete name in A2 of page 1, as well as matching all of the column B of Page 2 to the A4 cell of Page 1. So if I choose Alex as a name in Page 1, it outputs his effort grade for Zone as .75 in the red cell on Page 1.
Does that make sense?
Do I need an averageif equation? Or a index(match())?
I'm not very fluent with Excel yet & am trying to learn. If anyone can help me out or provide the resources to walk me through it, I would greatly appreciate it!
Thank you,
Matt
Example:
Page 2
Athlete Name | Type of block | Effort | Assignment | Technique |
Joe | Zone | 1 | 1 | .5 |
John | Pass | .75 | 1 | .75 |
Alex | Pass | 1 | .5 | .25 |
Alex | Zone | .5 | 1 | 0 |
John | Pull | 1 | .75 | 1 |
Alex | Zone | 1 | 1 | .5 |
Page 1
Athlete Name: | |||
Drop down list of names (Joe, John, Alex) | |||
Effort | Assignment | Technique | |
Zone | Average of Page 2 range that matches name & type here | ||
Pass | |||
Pull |
I'm trying to figure out how to write an equation that goes in the red text area of Page 1 that calculates all of Page 2 range that matches athlete name in column A of page 2 to the athlete name in A2 of page 1, as well as matching all of the column B of Page 2 to the A4 cell of Page 1. So if I choose Alex as a name in Page 1, it outputs his effort grade for Zone as .75 in the red cell on Page 1.
Does that make sense?
Do I need an averageif equation? Or a index(match())?
I'm not very fluent with Excel yet & am trying to learn. If anyone can help me out or provide the resources to walk me through it, I would greatly appreciate it!
Thank you,
Matt