Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-02-2018, 10:31 PM
mandersen04 mandersen04 is offline Help with Index/Match Formula Windows 10 Help with Index/Match Formula Office 2016
Novice
Help with Index/Match Formula
 
Join Date: Sep 2018
Posts: 12
mandersen04 is on a distinguished road
Default Help with Index/Match Formula


Hello.

I have compiled dozens of worksheets documenting NFL football standings by season (each worksheet is a season). On each worksheet, each team name is listed in column F, and each team's playoff result is listed in column T. I am creating an index sheet where I can input a team name in column A, the year in column B, and then create an index/match formula in column C to list that team's playoff finish. For example:


Team Year Playoff Finish

Buffalo Bills 1981 Lost Divisional Round


Whichever team and year I input in the first two columns, I want that to pull in that team's playoff finish from that given season based on what I have written in column T (of the given season). I need help with the index/match formula. I was able to do a formula that lists a specific season, but I need a formula that will reference whichever season I input in column B. I'm sure it involves an indirect reference, but I can't seem to get the syntax right.


Any help would be appreciated.


Also, bonus points if you can help me create a second index table listing the Super Bowl winner for each season. In each individual season, the Super Bowl winner is identified as "Super Bowl Champions" in column F. I want to be able to input the season in one column and subsequently pull in that season's champion in the adjacent column.


Again, any help with either problem would be appreciated.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Index/Match Formula How to make MATCH/INDEX formula return multiple successive responses. danigirl121 Excel 7 06-08-2016 01:57 PM
index / match Formula dmcg9760 Excel Programming 1 11-08-2015 03:16 PM
Help with Index/Match Formula Question about Index match formula to copy all of cells in row dmcg9760 Excel 1 11-08-2015 01:41 AM
Complex Formula using INDEX and Match needed OTPM Excel 5 05-23-2013 01:22 AM
Help with multiple match and index formula ryanwood Excel 1 09-12-2012 07:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft