Force Vlookup

[tlindeman]

I have a vlookup that refers to a spreadhseet that doesn't exist yet. I know that sounds silly, but I it will be created monthly, and I want to be able to have it lookup the data when it is created, however, excel is giving an error when I try to enter it, is there any way to force excel to accept the vlookup? Here is my formula:

=IF(ISERROR(VLOOKUP($A$6,[Indebtedness.xlsx]Schedule_Jun!$B$4:$F$64,5,FALSE))," ",VLOOKUP($A$6,[Indebtedness.xlsx]Schedule_Jun!$B$4:$F$64,5,FALSE))

THank You
Tony

 

[anglais428]

It will give an error because the file isn't created yet, so when you hit enter it is looking for something and finding nothing.

 

[SuperFerret]

If the sheet doesn't exist yet, could you not have a macro that evaluates IF the sheet is there and IF it does then put the VLOOKUP in?

 

[tlindeman]

Yes, that would be a great idea. If you know vba , could you give me the code. I am very limited in my VBA knowledge.

Thank You
Tony

 

[SuperFerret]

I've not got much time as I leave in a moment, this may help:
http://www.mrexcel.com/forum/showthread.php?t=3228