Use VLOOKUP in a Co-Authored Excel Workbook with a Server Workbook
Question details
The user wants to use VLOOKUP in a co-authored Excel workbook to retrieve data from another workbook stored on a server or desktop.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A shared workbook needs to look up values in a separate workbook using an external reference.
- Observed behavior
- The lookup should return data from the source workbook, but external links may behave differently in desktop Excel and Excel for the web.
Confirm that you can open both workbooks and that the source workbook contains the lookup values in the first column of the intended range. Check that collaborators who need to refresh the link can access the source file at the referenced location.
Create the External VLOOKUP Link in Desktop Excel
Use desktop Excel to create and update the lookup when the source workbook is accessible on a server or local drive.
Open the co-authored workbook in the Excel desktop application, then use File > Open to open the source workbook from its server or local location.
In the co-authored workbook, select the result cell and type =VLOOKUP(A2, replacing A2 with the cell containing your lookup value.
Type a comma, switch to the source workbook, and select the table range. Return to the formula and complete it with the return-column number and FALSE for an exact match, such as =VLOOKUP(A2,'[Source.xlsx]Sheet1'!$A$2:$C$100,2,FALSE).
Press Enter and save the co-authored workbook. When reopening it, follow any prompt to update links to the trusted source workbook, or use Data > Workbook Links or Data > Edit Links, depending on your Excel version.

Synchronize or Download the Source Workbook
Use a locally accessible copy when the server workbook cannot be opened directly from desktop Excel.
Work with VLOOKUP Tables in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files to work with lookup tables and migrate everyday spreadsheet tasks without leaving familiar formats. It does not fix external-link behavior in Excel for the web.

Frequently Asked Questions
Can Excel for the web update a VLOOKUP linked to another workbook?
External workbook links may not work or update reliably in Excel for the web, depending on the source and the available features. Open the workbook in desktop Excel and update the link there if the web result is unavailable or stale.
Why can't another collaborator refresh my VLOOKUP?
The source path may point to a file on your desktop or to a location the collaborator cannot access. Check Data > Workbook Links or Data > Edit Links and make sure the source is available to the people who need to update it.
How do I point an existing link to a downloaded source file?
In desktop Excel, open Data > Workbook Links or Data > Edit Links, select the source, and use the option to change its source. Choose the downloaded workbook and verify the lookup results.
What should I check if VLOOKUP returns the wrong value?
Check that the lookup value is in the first column of the selected source range and that the return-column number is correct. Use FALSE as the final argument when you need an exact match, and update the external link if the source data has changed.




