On Saturday 10 Sep 2011 15:29:55 Wade Smart wrote: > 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.
I don't follow your spreadsheet layout, but appending the style function should do what you want. -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
