SharePoint Cross-Site Lookup

Allow SharePoint users reference a list from deferent site on one site collection more easily.

SharePoint Cross-Site Lookup Tutorial:

The following is a typical example application of SharePoint Cross-Site Lookup.

Two lists have been built in two sites respectively. One is “ProductList" in Product Site, and the other is “ProfitTrackingList" in Sales Site.

Create a new column in ProfieTrackingList.

On “Create Column" page, choose “Cross-Site Lookup" column type and get information from ProductList in the Product Site:

Create a new item in “ProfitTracking" list and look at the Cross-Site Lookup column in action.

Edit Cross-Site Lookup column in “ProfitTrackingList" and select "Allow multiple values".

Edit item created in ProfitTrackingList.

In ProductList, you can create some views to show products with different product types.

Edit item in the ProfitTrackingList, you can select view to filter lookup items.

Edit Cross-Site Lookup column and select "Convert to SharePoint Lookup type".

Then you can edit ProfitTrackingList in Datasheet.