Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have two Excel files, one on D:\ and the other one onĀ E:\.

I reference one from the other, for example, using vlookup in the E: file to search from the D: file, like that:

VLOOKUP(A1,'D:\SHARIQ\[FILE NAME.XLS]SHEETNAME'!A1:10,3,FALSE)

As long as D:\SHARIQ\FILE NAME.XLS is open, I get the formula in the E: file displayed like this:

VLOOKUP(A1,'[FILE NAME.XLS]SHEETNAME'!A1:10,3,FALSE)

Why does it remove the whole path?

share|improve this question
    
Is there an actual problem, here? –  Iszi Sep 6 '12 at 0:32
    
@Iszi Does there have to be? –  JoshP Sep 6 '12 at 15:02
    
@Josh Per the faq: "You should only ask practical, answerable questions based on actual problems that you face" Unless there's actually a problem caused by the program functioning in this manner, the question becomes one of design choice - a question that nobody on this site (unless they happen to be a Microsoft employee involved in the process) can reasonably be expected to answer in truth. –  Iszi Sep 6 '12 at 15:55
    
@Iszi, I understand what you are saying. However, the original question was, "how to add full file path in vlookup formula?" It has been edited down to, "Why does it remove the whole path?" I think the original question certainly conforms, and if the question (as it has been edited) can only be answered with a "it was apparently a design choice," that doesn't change the "answerability" of the question. –  JoshP Sep 6 '12 at 16:06

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.