Forum Discussion
Data connection between two Sharepoint files
Hi All, I have two excel files stored in Sharepoint. For a column from the first file I need to fetch the data from the second file. I could do this with a Vlookup, but the connection is not very...
1. Merge both the files into one with 2 separate tabs.
2. Consider creating SharePoint lists with a lookup column data type if your excel files are small.
3. Use MS access and import SharePoint lists as tables
4. You could use .iqy file extension if your data is stored in a SharePoint list.
2. Consider creating SharePoint lists with a lookup column data type if your excel files are small.
3. Use MS access and import SharePoint lists as tables
4. You could use .iqy file extension if your data is stored in a SharePoint list.