Vlookup - Sharepoint list from Excell file on Sharedrive/Sharepoint
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
June 16th, 2011 4:55pm

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/
Free Windows Admin Tool Kit Click here and download it now
June 16th, 2011 11:39pm

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
June 16th, 2011 11:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics