VLLOKUP across multiple workbooks

V

vin

One of our Financial analyst is using VLOOKUP formula using 2-3
different workbooks. Formula on workbook 1 is

=IF(AsofDate_Match_YN,VLOOKUP(I$471,'\\server1\Performance Data\
[Summary Reports.xls]Summary1'!$A$1:$AZ$10,4,FALSE),NA())*100


Problem is actually with file path. There's a mapping to \\server1 as
F drive and whenever we change the above formula to reflect F:
\Performance Data, after opening the file again it reverts back to \
\server1\
How can we put persistant F:\
Thanks!
 
T

tristan.huxley

Hi,

I'd suggest that if you have a lot of these formulas, that what you
can do is select all of the rows or column's and use Find/Replace (Ctrl
+H), and in the Find dialogue, put in ,'\\server1\ and in the replace
dialogue put in 'F:\

This will find all related formula's that have this, and change them
all accordingly... Beware though... If you have alot of these to
change, it might be best for you to make a copy of this and apply the
change to the copy first, and do your testing with that, and if happy,
save over the old one with these new changes... It's important that
you do your testing to make sure that it works the way you expect it
to...

Hope this helps you!!!
 
Top