Working in Excel with an exported SahrePoint List into Excel.

trainingthefuture You mention that you want to "link" VLOOKUP to "this query table". Are you, by any chance, using Power Query to connect to a Sharepoint folder?

trainingthefuture 

I am definitely not one of the SharePoint specialists. But that doesn't mean that I can't provide any information to help. Here is some information - possibilities that I could memorize on the Internet.

Connecting to SharePoint-Based Excel File

There is also this way:

Linking excel to-> Access to-> Sharepoint

Create a sharepoint list. Link this to with Access.

Then you can export the list under "Actions" into a "Spreadsheet" (Excel) in Sharepoint. This works with any library or list. In the case of document libraries, the documents are even displayed as hyperlinks in the Excel lists.

This is now "linked" to Excel as an Excel list (the data area is outlined in blue). To "synchronize" the data you go to the Excel toolbar. A "List" symbol group should now appear there (list / switch result line / synchronize list / discard and update changes).

Synchronize list synchronizes the data with the SharePoint list. If you have write access to the Sharepoint list, you can also update the data via Excel and synchronize it with the Sharepoint list. This data then appears again immediately in your access database.

Import, link, or move data to SharePoint

for Access 2019 SharePoint in Microsoft 365 Access 2016 Access 2013 Access 2010 Access 2007

Here is another VBA approach:

Public Sub Sharepoint_Verknüpfen()
    On Error Resume Next
    DoCmd.DeleteObject acTable, "TabellenName"
    On Error GoTo 0
    DoCmd.TransferDatabase acLink, "WSS" _
                         , "WSS;HDR=NO;IMEX=2;" _
                         & "DATABASE=https://adresse.ch/sharepointtabelle;" _
                         & "LIST={DKSDJFJsd10-3432-4DSD-8085-3ADB46C5E138};" _
                         & "VIEW=;RetrieveIds=Yes;TABLE=Parts", acTable, _
                         , "TabellenName"
End Sub

If that's not what you're looking for, just ignore it.

At the same time, I would be happy to find out if it helped you.

Wish you a nice day.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.