I have a specific date in cell N1 field: 09/16/2007
I am taking only the month to generate the name of an Array called "SEPTAB".
SEPTAB is the name of an array in a different worksheet. I want to use the
date for the vlookup to the spread sheet that has the "SEPTAB" Array. Here
are my values.
Cell $n$1 contains 09/16/2007
Array ChuckTAB has: =IF((LEFT(N1,2)="09"),"SEPTAB","09") which returns
"SEPTAB" properly and this statement is on line 9 of the ChuckTab array.
I am then using it like:
=VLOOKUP($N$1,'G:\mysubvol\Accounting\BadDog2007Mo nthly.xls'!INDEX(Chuckindex,(LEFT($N$1,2))),12)

It should build this formula when the values are expanded
=VLOOKUP(09/16/2007,'G:\mysubvol\Accounting\BadDog2007Monthly.xls '!SEPTAB,12)

I hope I am just missing something subtle.