VLLOKUP across multiple workbooks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vin@vineetsab.com - 09 Feb 2007 16:08 GMT

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!

Reply to this Message

tristan.huxley@prox-e-mics.eu - 13 Feb 2007 12:41 GMT

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!!!

On Feb 10, 3:08 am, v...@vineetsab.com wrote:

> One of our Financial analyst is using VLOOKUP formula using 2-3
> different workbooks. Formula on workbook 1 is
[quoted text clipped - 8 lines]
> How can we put persistant F:\
> Thanks!

Reply to this Message