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