Kenja824
Automotive
- Nov 5, 2014
- 950
My original index match formula was this...
=IF(ISNA(INDEX(E:E,MATCH($T3,$B:$B,0))),0,INDEX(E:E,MATCH($T3,$B:$B,0)))
This searched column B:B for a name of an NFL player"T3" and returned the total Touchdowns for the season which was in column B:B.
I have now placed a total of three years worth of stats in the range. Which means the player's name will be listed in three different rows. In column A:A is the year for each row of stats.
So now I need the formula to return the Touchdowns, which is in column E:E that not only coincides with the correct players name in column B:B, but also the correct year in column A:A
In case I didnt make sense, another way to say it is.... S3 = 2015 .... T3 = Aaron Rodgers
If Aaron Rodgers is in the same row as 2016 OR 2014 it will be ignored.
The number in column E:E and in the same row as Aaron Rodger and 2015 will be returned.
I would upload my workbook but I had a bunch of other formulas all over it in testing and old ones I started with the thing is just one big mess right now. lol I started using VLookups and was switching to Index Match formulas when I ran into this.
=IF(ISNA(INDEX(E:E,MATCH($T3,$B:$B,0))),0,INDEX(E:E,MATCH($T3,$B:$B,0)))
This searched column B:B for a name of an NFL player"T3" and returned the total Touchdowns for the season which was in column B:B.
I have now placed a total of three years worth of stats in the range. Which means the player's name will be listed in three different rows. In column A:A is the year for each row of stats.
So now I need the formula to return the Touchdowns, which is in column E:E that not only coincides with the correct players name in column B:B, but also the correct year in column A:A
In case I didnt make sense, another way to say it is.... S3 = 2015 .... T3 = Aaron Rodgers
If Aaron Rodgers is in the same row as 2016 OR 2014 it will be ignored.
The number in column E:E and in the same row as Aaron Rodger and 2015 will be returned.
I would upload my workbook but I had a bunch of other formulas all over it in testing and old ones I started with the thing is just one big mess right now. lol I started using VLookups and was switching to Index Match formulas when I ran into this.