Hello,
I have a worksheet with an INDEX formula in it, it works great for 95% percent of what I want it to do, for some reason though, I can't figure out the last 5%.
In my attached workbook, I have two sheets (Draft and Sheet 2). I want 'Sheet 2' to pull info from 'Draft' based on what is selected in the drop down menus for cells I13:36 of the draft sheet.
For example, let's say Jose Abreu, the name listed in cell C19 is selected to Team 1, he should thus end up in cell D8 of Sheet 2 because he was the first player chosen to Team 1. This does happen when you select it, the problem I'm running into is if a player above him on the Draft List is also chosen to Team 1 it bumps down the first guy Jose Abreu to cell D9 when he should stay at cell D8 and the newly selected player goes to cell D9 because he was the second player chosen by that team.
Does anyone know how to get the first player selected by a team to stay in the 1st slot of that team no matter the list? And likewise with all the other numbers and so on.
Any help would be greatly appreciated. Thanks!
Bookmarks