Using VLOOKUP in multiple sheets using
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\Per formance 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!
|