Changing the date within a Vlookup formula 2

[Mizzness]

All.

I have a vlookup formula that includes a date within the file it is referencing.
How can I copy this down and have the date change ?
Example:=VLOOKUP(A4,'U:\MBS\Whitesheets\2005\Nightly Board\March\[mar 21.xls]Sheet1'!$A:$L,12,FALSE)would have to change to mar 22 when copied down.

Thanx in advance.

 

[AnotherHiggins]

Brad,

At least in 2000, which I use here at work.

On a hunch I removed the Analysis Toolpak. Then I wrote a simple indirect function, which failed.

I installed Analysis Toolpak again and the function works.

Glad you've got it sorted out, Mizzness.


[tt]_____
[blue]-John[/blue]
[/tt][red]"If you're flammable and have legs, you are never blocking a fire exit."[/red]
-Mitch Hedberg

Help us help you. Please read FAQ181-2886 before posting.

 

[Mizzness]

I use XP Pro and that DEFINITELY was the issue.

 

[byundt]

John,
There must be more than one flavor of Excel 2000, then. I turned off all the add-ins in my US edition of Excel 2000, closed the application, then relaunched it. Formulas using INDIRECT worked perfectly.

Ditto with Excel 97, 2002 and 2003.
Brad

 

[SkipVought]

INDIRECT is NOT an add-in. Check Help!

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[AnotherHiggins]

Hmmm. It sure seemed to work that way when I tested it....

Mizzness, is your other workbook (the one that the function refers to) open? If so, close it. You should get the #REF! error regardless of whether you are using the INDIRECT function or not. That's another good reason to consider storing all of your data in a single table.

Perhaps you just coincidentally opened the referred-to workbook when you installed Analysis Toolpak?

[tt]_____
[blue]-John[/blue]
[/tt][red]"If you're flammable and have legs, you are never blocking a fire exit."[/red]
-Mitch Hedberg

Help us help you. Please read FAQ181-2886 before posting.

 

[Mizzness]

John,

The workbook was already opened.
The function/tab I sm referring to is within the same workbook.
I closed and re-opened it and all is well on this front.

Hope this helps or clarifies.

Mizzness