Hi amazing excel formula minds,
I've been trying to extend my current formula to span about 11 different rosters (in another tab titled Roster!), but I havent had much luck extended the below:
=IFERROR(IF($C$7=Roster!$C$2,INDEX(Roster!$C:$C,MATCH(F$10,Roster!$B:$B,0)),IF($C$7=Roster!$D$2,INDEX(Roster!$D:$D,MATCH(F$10,Roster!$B:$B,0)),IF($C$7=Roster!$E$2,INDEX(Roster!$E:$E,MATCH(F$10,Roster!$B:$B,0)),""))),"")
Basically just need the top replicated 11 times (each index match is for 1 roster type names go across ie. $C$2, $D$2, $E$2 etc through to $M$2) and roster patterns associated to each roster name go down the list ie. $C:$C, $D:$D, $E:$E etc through to $M:$M, the match codes will remain the same throughout the formula - hope this makes sense.
I usually just copy and paste entire IF(Index, Match) formula to replicate, but I cant quite figure out the end part where the closing parenthesis goes
Any help would be amazing!
Thank you in advance
I've been trying to extend my current formula to span about 11 different rosters (in another tab titled Roster!), but I havent had much luck extended the below:
=IFERROR(IF($C$7=Roster!$C$2,INDEX(Roster!$C:$C,MATCH(F$10,Roster!$B:$B,0)),IF($C$7=Roster!$D$2,INDEX(Roster!$D:$D,MATCH(F$10,Roster!$B:$B,0)),IF($C$7=Roster!$E$2,INDEX(Roster!$E:$E,MATCH(F$10,Roster!$B:$B,0)),""))),"")
Basically just need the top replicated 11 times (each index match is for 1 roster type names go across ie. $C$2, $D$2, $E$2 etc through to $M$2) and roster patterns associated to each roster name go down the list ie. $C:$C, $D:$D, $E:$E etc through to $M:$M, the match codes will remain the same throughout the formula - hope this makes sense.
I usually just copy and paste entire IF(Index, Match) formula to replicate, but I cant quite figure out the end part where the closing parenthesis goes
Any help would be amazing!
Thank you in advance