Forum Discussion

trainingthefuture's avatar
trainingthefuture
Copper Contributor
Feb 20, 2021
Solved

Working in Excel with an exported SahrePoint List into Excel.

Hi I am quite new to world of 365.   I have exported a number of SharePoints lists to an Excel workbook - all in the same book just on different sheets.   But I can't link (Vlookup) to this Query...
excel
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 20, 2021

    trainingthefuture 

    I could only make I guess that you lookup numbers. Numbers imported from SharePoint list in Excel will be presented as texts, thus in lookup column you have texts. If so you may try

    =VLOOKUP(M2 & "", 'Staff Matrix'!$A:$B, 2)

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 20, 2021

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's avatar
trainingthefuture
Copper Contributor
Feb 20, 2021

Riny_van_Eekelen Hi I am exporting the Sharepoint List via the export button on SharePoint, then opening them and adding them to the excel sheet. 

 

I would use a Vlookup like: =VLOOKUP(M2, 'Staff Matrix'!$A:$B, 2), but this doesn't return any value when the file Staff Matrix has been imported from SharePoint. 

Resources