Hello - I'm trying to work out a formula that will lookup the Team Name and Position and return the Names, horizontally.
For example:
QB QB QB QB QB RB RB WR
Chiefs- Jim Tom Jeff Aaron Steve
Panthers- Mike Connor Erick Andrew Nick
Data:
Team Position Name
Chiefs QB Jim
Chiefs QB Tom
Chiefs QB Jeff
Panthers QB Mike
Panthers QB Connor
Chiefs RB Aaron
Chiefs RB Steve
Panthers WR Nick
Panthers QB Erick
Panthers QB Andrew
I've developed the following formulas but am still encountering issues with both.
1) =IF(COLUMNS($G2:G2)>$B$21,"",INDEX($C$2:$C$11,SMALL(IF($A$2:$A$11=$F$2,ROW($A$2:$A$11)-ROW($A$2)+1),COLUMNS($G2:G2))))
** I cannot get this formula to differentiate between teams
2) =INDEX($C$2:$C$11,MATCH($F5&G$1,INDEX($A$2:$A$11&$B$2:$B$11,),0))
** I cannot figure out how to nest a SMALL formula in here in order to ignore duplicates and take the next values
Bookmarks