2011/9/10 Wade Smart <[email protected]>: > Im trying to figure out how to make that work. > > on Tab 2 = teams. > > ColumnA > Row 12 - 14 = number of players > > ColumnB > Row 12 - 14 = Player Jersey Number & Player name > > ColumnC > I put a 1 next to the captain > > Comumn D - > the next team > > Ok. On Tab 1 = Game form. > H10 = I type in the Home team (ex: 1) > K10 = I type in the Away team (ex: 4) > > K18 is my vlookup. > =VLOOKUP($E18,$Teams.$A$12:$N$26,($H$10+1),0) > > So it looks at which team Ive put down and then > gets that roster of players. > > So, from ColumnC above - if I insert that column, > when I type in say 2 on my game form, its only > going to pull a 1 because that is the captain column. > > Im not sure how to get around that yet.
And where is your conditional formatting? You did explore [Format → Conditional formatting], didn't you? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
