On Sat, Sep 10, 2011 at 14:15, Johnny Rosenberg <[email protected]> wrote: > 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 >
Well, I didnt get to the conditional formatting because of the vlookup layout problem that I posted above. -- -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
