Re: vlookup question

On Sat, Sep 10, 2011 at 12:58, Rob Weir <[email protected]> wrote:
> On Sat, Sep 10, 2011 at 1:35 PM, Wade Smart <[email protected]> wrote:
>> I have two tabs: tab1 is my game form and tab 2 is my player roster.
>>
>> When I put in the team name on tab1 it populates the players from
>> tab 2.
>>
>> This year the league mandated rosters have sequential numbering
>> of players on the game forms. The captains are in bold on tab 2.
>> When they appear on the game form though, that formatting does
>> not carry over.
>>
>> How can I carry over that bold formatting from tab 2 to tab 1 with
>> vlookup?
>>
>
> Have you tried conditional formatting?   If you have a column that
> expresses whether the given row is a captain or not (value of 1 or 0)
> then you could use conditional formatting to make the copied values be
> bold or not based on that column.
>
> More info on conditional formatting here:
>
> http://openoffice.blogs.com/openoffice/2007/01/conditional_for.html
>
> -Rob
>
>> Wade
>>
>> --
>> --
>> 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
>>
> --
> -----------------------------------------------------------------
> To unsubscribe send email to [email protected]
> For additional commands send email to [email protected]
> with Subject: help
>

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.



-- 
--
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