locked
Vlookup - Sharepoint list from Excell file on Sharedrive/Sharepoint RRS feed

  • Question

  • Hi,

    can I use vlookup in Sharepoint list from Excell file on Sharedrive?

    Is it needed the Excel file is present on the Sharepoint site or even exists as a list in Sharepoint?

    What is the "user" Sharepoint would be visible as to the share drive. We need to allow this Sharepoint to access the share drive?--> but really as Excell needs file to open to allow for vlookup, I think that peroforming vlookup on an unopened file is probably not possible in Sharepoint, correct?

    Thank you,

    Petr

    Thursday, June 16, 2011 1:55 PM

All replies

  • Do you mean on the actual list itself or a linked spreadsheet?  You can export a linked sharepoint list to an excel sheet and then use any of the Excel client functionality with it, if that´s of any use for you?
    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Thursday, June 16, 2011 8:39 PM
    Answerer
  • In the Sharepoint list I want to use a vlookup function, to get data in from a different list.
    I want to know which of these scenarios are possible:

    The list to lookup from is:

     -a document in document library on the same sharepoint site.
    -a list on the same sharepoint site.
    -a list on a different sharepoint site.
    -an excell file on a sharedrive

     

    Rgds,Petr

    Thursday, June 16, 2011 8:55 PM