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'm trying to use use vlookup to access another excelsheet on a network drive.

Currently I have a vlookup that works fine

=VLOOKUP(A2;'H:\CVO\[test.xlsx]Sheet1'!$A$1:$C$4;2;)

However I cannot seem exhange the H:\ with the server address //pcpfile10/Corporate/.

I need to link to the network address, since other users do not necessary have H-drive mapped to the same server as I do.

Anyone can help me out?

share|improve this question

closed as too localized by Dave, Brad Patton, 8088, Dave M, CharlieRB Apr 16 '13 at 16:59

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center. If this question can be reworded to fit the rules in the help center, please edit the question.

    
Don't you need to use backslashes instead if it is local? –  Dave Apr 15 '13 at 13:09
    
I wasn't sure if it should be back or forward, but it didn't fix the error - but I accidently found the error while testing it so thanks! –  Casper Apr 15 '13 at 13:23

1 Answer 1

up vote 1 down vote accepted

It turned out that it was excel autocorrect when pressing ENTER, which "fixed" the link to include a letter link.

If I added the correct network link (using backslashs), and simply clicked away from the field, then excel didn't try to fix it with an error.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.