Paul has attended:
Excel Advanced course
VLOOKUP / editing links
Hi,
I use a vlookup which references data from a different workbook. The (reference) workbook has now been changed & renamed. I need to edit links but I cannot get this to work correctly.
In my original vlookup formula I have included the spreadsheet name in additon to the full directory pathway preceded by ' and ended with '!
as follows:
"=VLOOKUP($B$6,'G:\sub\subdir\subsubdir\paul\paul1\paul LOG\[paul LOG as of 17-MAR-14.XLS]paul Log'!$1:$65536,3, FALSE)"
thank you
RE: vLOOKUP / editing links
Hi Paul
Thank you for your question.
If the workbook has just been renamed but its structure remains the same, the easiest way to get this work would be to use Edit Links button on the Data tab. In the dialog box that appears click on the Change Source button and browse to the new file that contains the data table. This should solve the problem, but if it doesn't work, please let us know.
Also, the link below will provide you with some useful information about using Vlookup between different workbooks and will also give you some examples of how the formula is displayed in the source workbook if you wanted to edit it. Please note that the formula will appear differently depending on whether the workbook containing the data table is open or closed. If this workbook is open, the file path is not displayed but if the workbook is closed, the full file path will be shown.
http://blog.contextures.com/archives/2010/08/23/excel-vlookup-from-another-workbook/
I hope this helps.
Kind regard
Anna Rozyk
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector [More]
