Re: vlookup question
Johnny Rosenberg <[email protected]>
| Newsgroups | gmane.comp.openoffice.questions |
|---|---|
| Message-ID | <CADo7T4fYAy+iLoHsMpqfhobfaH44KqP3mad17bLGsXFCxFNdYQ@mail.gmail.com> |
2011/9/10 Wade Smart <[email protected]>: > 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. Okay, then I guess I don't understand your question. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help