Re: vlookup question

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