[users] Re: vlookup question

2011-09-12 Thread Martin du Saire
On Sat, Sep 10, 2011 at 9:30 PM, Wade Smart wadesm...@gmail.com wrote: On Sat, Sep 10, 2011 at 17:00, Wade Smart wadesm...@gmail.com wrote: On Sat, Sep 10, 2011 at 16:43, Barrie Backhurst barrie.backhu...@ntlworld.com wrote: On Saturday 10 Sep 2011 15:29:55 Wade Smart wrote: On Sat, Sep

[users] Re: vlookup question

2011-09-12 Thread Richard Saunders
Why are you sending these e mails to me? Richard On 9/12/2011 9:00 AM, Martin du Saire wrote: On Sat, Sep 10, 2011 at 9:30 PM, Wade Smart wadesm...@gmail.com mailto:wadesm...@gmail.com wrote: On Sat, Sep 10, 2011 at 17:00, Wade Smart wadesm...@gmail.com mailto:wadesm...@gmail.com

[users] Re: vlookup question

2011-09-12 Thread Wade Smart
2011/9/12 Richard Saunders richa...@well.com: Why are you sending these e mails to me? Richard On 9/12/2011 9:00 AM, Martin du Saire wrote: On Sat, Sep 10, 2011 at 9:30 PM, Wade Smart wadesm...@gmail.com wrote: On Sat, Sep 10, 2011 at 17:00, Wade Smart wadesm...@gmail.com wrote: On Sat,

[users] Re: vlookup question

2011-09-11 Thread Johnny Rosenberg
2011/9/10 Wade Smart wadesm...@gmail.com: On Sat, Sep 10, 2011 at 14:15, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2011/9/10 Wade Smart wadesm...@gmail.com: Im trying to figure out how to make that work. on Tab 2 = teams. ColumnA Row 12 - 14 = number of players ColumnB Row 12 -

[users] Re: vlookup question

2011-09-11 Thread Barrie Backhurst
On Saturday 10 Sep 2011 21:30:13 Wade Smart wrote: On Sat, Sep 10, 2011 at 17:00, Wade Smart wadesm...@gmail.com wrote: On Sat, Sep 10, 2011 at 16:43, Barrie Backhurst barrie.backhu...@ntlworld.com wrote: On Saturday 10 Sep 2011 15:29:55 Wade Smart wrote: On Sat, Sep 10, 2011 at

[users] Re: vlookup question

2011-09-10 Thread Rob Weir
On Sat, Sep 10, 2011 at 1:35 PM, Wade Smart wadesm...@gmail.com 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

[users] Re: vlookup question

2011-09-10 Thread Wade Smart
On Sat, Sep 10, 2011 at 12:58, Rob Weir r...@robweir.com wrote: On Sat, Sep 10, 2011 at 1:35 PM, Wade Smart wadesm...@gmail.com 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

[users] Re: vlookup question

2011-09-10 Thread Johnny Rosenberg
2011/9/10 Wade Smart wadesm...@gmail.com: 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 =

[users] Re: vlookup question

2011-09-10 Thread Wade Smart
On Sat, Sep 10, 2011 at 14:15, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2011/9/10 Wade Smart wadesm...@gmail.com: 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

[users] Re: vlookup question

2011-09-10 Thread Barrie Backhurst
On Saturday 10 Sep 2011 15:29:55 Wade Smart wrote: On Sat, Sep 10, 2011 at 14:15, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2011/9/10 Wade Smart wadesm...@gmail.com: Im trying to figure out how to make that work. on Tab 2 = teams. ColumnA Row 12 - 14 = number of players

[users] Re: vlookup question

2011-09-10 Thread Wade Smart
On Sat, Sep 10, 2011 at 16:43, Barrie Backhurst barrie.backhu...@ntlworld.com wrote: On Saturday 10 Sep 2011 15:29:55 Wade Smart wrote: On Sat, Sep 10, 2011 at 14:15, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2011/9/10 Wade Smart wadesm...@gmail.com: Im trying to figure out how to make

[users] Re: vlookup question

2011-09-10 Thread Wade Smart
On Sat, Sep 10, 2011 at 17:00, Wade Smart wadesm...@gmail.com wrote: On Sat, Sep 10, 2011 at 16:43, Barrie Backhurst barrie.backhu...@ntlworld.com wrote: On Saturday 10 Sep 2011 15:29:55 Wade Smart wrote: On Sat, Sep 10, 2011 at 14:15, Johnny Rosenberg gurus.knu...@gmail.com wrote: