Re: Indirect and Address problem (from VLOOKUP and Macros)

2013-10-03 Thread John Meyer
Strike that last e-mail, it worked. On 10/3/2013 11:57 AM, John Meyer wrote: On 10/3/2013 11:42 AM, Brian Barker wrote: At 10:59 03/10/2013 -0600, John Meyer wrote: After looking over this problem a bit, I decided to scrap the sheet name idea and just have all sales on one sheet. sales are i

Re: Indirect and Address problem (from VLOOKUP and Macros)

2013-10-03 Thread John Meyer
On 10/3/2013 11:42 AM, Brian Barker wrote: At 10:59 03/10/2013 -0600, John Meyer wrote: After looking over this problem a bit, I decided to scrap the sheet name idea and just have all sales on one sheet. sales are in this format: DummyField, Date, DummyField, DummyField, SalesRep For this tab

Re: Indirect and Address problem (from VLOOKUP and Macros)

2013-10-03 Thread Brian Barker
At 10:59 03/10/2013 -0600, John Meyer wrote: After looking over this problem a bit, I decided to scrap the sheet name idea and just have all sales on one sheet. sales are in this format: DummyField, Date, DummyField, DummyField, SalesRep For this table, I want to get the number of sales genera

Re: Indirect and Address problem (from VLOOKUP and Macros)

2013-10-03 Thread John Meyer
Thanks for the help. After looking over this problem a bit, I decided to scrap the sheet name idea and just have all sales on one sheet. sales are in this format: DummyField, Date, DummyField, DummyField, SalesRep For this table, I want to get the number of sales generated for a particular

Re: Indirect and Address problem (from VLOOKUP and Macros)

2013-10-03 Thread Brian Barker
At 08:47 03/10/2013 -0600, John Meyer wrote: http://i174.photobucket.com/albums/w108/pueblonative/FormulaError2_zps27abcf42.png http://i174.photobucket.com/albums/w108/pueblonative/Formulaerror1_zpsda33a4c4.png Here are the worksheet names and the formula I am using. I haven't been following th

Indirect and Address problem (from VLOOKUP and Macros)

2013-10-03 Thread John Meyer
http://i174.photobucket.com/albums/w108/pueblonative/FormulaError2_zps27abcf42.png http://i174.photobucket.com/albums/w108/pueblonative/Formulaerror1_zpsda33a4c4.png Here are the worksheet names and the formula I am using.