I'm sure this will be easy for one of you. I'm close, need a final tweak.
I have a table of kids names with batting order in column1 (B3:B16), Inning # in row1 (C2:H2) and position they are playing each inning (1B, 2B, SS, etc.) scattered throughout the table.
I'd like to create a unique cell for each fielding position, and be able to change a separate drop-down selector for the inning (in B18), and have the kids name populate in that cell. 1st inning is working, but not when I try to expand beyond the first column. Do I need to convert to an array?
=INDEX($B$3:$B$16,MATCH("LF",$C$3:$C$16,0),MATCH($B$18,$C$2:$H$2,0))
I have a table of kids names with batting order in column1 (B3:B16), Inning # in row1 (C2:H2) and position they are playing each inning (1B, 2B, SS, etc.) scattered throughout the table.
I'd like to create a unique cell for each fielding position, and be able to change a separate drop-down selector for the inning (in B18), and have the kids name populate in that cell. 1st inning is working, but not when I try to expand beyond the first column. Do I need to convert to an array?
=INDEX($B$3:$B$16,MATCH("LF",$C$3:$C$16,0),MATCH($B$18,$C$2:$H$2,0))
Batting Order | 1st Inning | 2nd Inning | 3rd Inning | 4th Inning | 5th Inning | 6th Inning |
Hudson | LCF | SS | 3B | P | P | |
Bradley | SS | LCF | SS | 1B | ||
AJ | P | P | 3B | 1B | SS | |
Kahl | C | C | P | P | 3B | |
Brantley | RF | 2B | RCF | 2B | ||
Griffin | 2B | C | C | LCF | ||
Rowdy | 1B | 1B | RF | C | C | |
Liam | 3B | 1B | 1B | 3B | ||
Lucas | RCF | 3B | LF | SS | ||
Elijah | RCF | SS | 2B | LF | ||
Josiah | RF | LF | 2B | LCF | ||
Gavin | LF | LCF | RF | RF | ||
Dane | LF | RCF | LF | RCF | ||
Kasen | 2B | RCF | LCF | RF |