Hi Friends,
I am new to excel coding. I am trying to use vlookup formula to get
data from other file which is residing in my EXCEL default directory.
Please see the Example..
I have File name called File_A which is resides in my default directory
(C:\Excel\)
I have File name called File_B and writing a vlookup formula in this
file.. the formula is like this..
=Vlookup(A1,File_A.xls!Rangename,2).
But As soon as I come out of this cell, the formula is getting change
to
=Vlookup(A1,C:\EXCEL\File_A.xls!Rangename,2).
What I want here is, I do not want to specify the path (C:\Excel\). The
formula should automatically recoganice the default path and look for
File_A file and retrive a data.. Could any one respond to my mail
please..
my email id is
..
Thanks in advance
Vish
--
rviswesw
------------------------------------------------------------------------
rviswesw's Profile: http://www.excelforum.com/member.php...o&userid=25289
View this thread:
http://www.excelforum.com/showthread...hreadid=384559