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)

     

trainingthefuture's avatar
trainingthefuture
Copper Contributor
Feb 20, 2021

NikolinoDE Thank you for your response, is Access included within within 365?. 

 

I think the issue is that a Vlookup doesn't connect to the imported SharePoint List data.

 

Is the imported SharePoint List file a data file or a query file? 

 

I will try your suggestions and report back. 

Resources